Question

6.
Write SQL commands for the queries given based on a relation CLUB shown below.
Create the table given with suitable datatypes and add the records as follows:
AGE
FEES
TYPE
MCODE
GENDER
MNAME
Male
35
7000
Ashish
1
Monthly
Monthly
25
Female
8000
2
Annanya
Gitika
Female
42.
24000
3
Yearly
Harshika
27
Female
4
12000
Tarun
54
Male
5
6000
Quarterly
Monthly
Monthly
Krishna Kant
6
Male
43
4500
Farida
22
Female
500
7
Guest
Jatin
51
Male
24000
8
Yearly
Rakshit
9
Male
44
1000000 Life
Pratap
10
Male
33
12000
Quarterly
a. Display the member name, age, fees of all members
b. To display the member names of all members whose membership fees is above 15000
c. Display code, name and age of all female members
d. Display all details of female members of the club
e. Display all the details in descending order of age
f. Display member details in ascending order of Mname of all female members
g. Display the membership details of all Monthly and Quarterly subscribers
h. Display the types of subscription available
i. Add a new record in the table.​

Answer 1

Answer:

qwertyyiopajsdkflglvc