Question

Write SQL commands for (a) to (e) on the basis of FAMILY relation given
below :
No. Name
Female
Male
Members Members
Income (Rs.)
Occupation
1. Mishra
2
Gupta
7,000
50,000
Service
Business
3
Khan
8,000
Chadda
25,000
Mixed
Business
5
1-malaam
own
20,000
Yadav
6 Joshi
7. Maurya
8 Rao
Mixed
14,000
5,000
Service
Farming
Service
10,000
a)
To select all the information of family whose occupation is se
b)
to list the name of family,where female members are more then 3.
c)
to list the name's of family with income in ascending order
d)
to list family's name, number of male members & their business of business family
e)
to count the number of family, whose income is less than RS.10,000​

Answer 1

Answer:

Explanation:

a) SELECT * FROM family WHERE Occupation='Service';

b) not sufficient question

c) SELECT Name, Income FROM family ORDER BY Name ASC;

d) not sufficient question

e) SELECT COUNT(*) FROM family WHERE Income<10000;

Answer 2

Answer:

The correct answer is SQL commands.

Explanation:

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

Answer:

SELECT * FROM family WHERE Occupation='Service';

b)to list the name of family,where female members are more then 3.

Answer:

SELECT Name, FROM family where < 3;

c)to list the name's of family with income in ascending order

Answer:

SELECT Name, Income FROM family ORDER BY Name ASC;

d)to list family's name, number of male members & their business of business family

Answer:

SELECT*FROM family WHERE Occupation =’Business’

e)to count the number of family, whose income is less than RS.10,000

Answer:

SELECT COUNT(*) FROM family WHERE Income<10000;

#SPJ3