Question

write SQL command
I of FAMILY relation
the basis
for (a) to (e) on
given below:
Female
members
Name
members
male
member
8 ooo
25000
20,000
mixed
14,000
5,000
farming
In comelns) occupation
mishra
7,00
service
Gupta
50,000 :
Business
Khan
mixed
chadda
Business
yadav
Yoshi
service
Maurya 6
Rao | 5
I 10,000 service
(a) to select all the information of family whose occupation
is service.
(6) To lest the names of family, where female members are
more then & more than 3
(C) To list names of family with income in ascending order
(d) To list family is name, number of male member and
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) SELECT Name FROM family WHERE FemaleMembers>3;

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

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