12th CMS || Practical Solutions || Database and SQL || 2021-2022

 

 

 

 

 

 a) To select all the information of family whose occupation is service.

   SELECT * from family 

   where occupation="service"

      

 

 

 

 

b) To list the names of family, where female members are more than 3

  SELECT name from family

  where femalemembers>3

 

c) To list the names of family with income in ascending order.

   SELECT name, income from       family

   order by income asc

 

 

 

 

d d) To list family name, number of male members and their business of business family

S  SELECT name, malemembers,   occupation from family

w  where occupation="business"

 

e) To count the number of family whose income is less than 10000.

 

SELECT count(*) from family

where income<10000

12th CMS || Database Concept || 

https://youtu.be/ABUc4RA0slU