Question

1. Write simple queries for the following:

a. Display all details for females.
b. Display coach name, gender who charge a fee less than 1500.
c. Display details for only swimming as a sport.
d. Display details of all records whose fees are in between 1000 and
1500;
e Display details for those whose name ends with a.
f. Display the details of the mean Charge more than +1500

Answer 1

a. Display all details for females.

• Select * from Club where Gender = 'F';

b. Display the coach name and gender of those whose charge fee is less than 1500.

• Select CoachName, Gender from Club where Fees < 1500;

c. Display details for only those who have swimming as a sport.

• Select * from Club where Sport = 'Swimming';

d. Display details of all records whose fee is in between 1000 and 1500.

• Select * from Club where Fees between 1000 and 1500;

e. Display details for those whose name ends with a.

• Select * from Club where CoachName like '%a';

f. Display the details of those whose fee charge is more than 1500.

• Select * from Club where Fees > 1500;

Answer 2

QuestioN :-

Write simple queries for the following →

• Display all details for females.

⠀⠀

• Display coach name , gender who charge a fee less than 1500

⠀⠀

• Display details for only swimming as a sport.

⠀⠀

• Display details of all records whose fees are in between 1000 and 1500.

⠀⠀

• Display details for those whose name ends with "A".

⠀⠀

• Display the details of the mean charge more than +1500

⠀⠀

AnsweRs :-

$\star \: \sf Display \: all \: details \: for \: females \: \mapsto$

⠀⠀

• Select * from club where Gender = 'F' ;

⠀⠀

$\star \sf \: Display \: coach name \: , \: gender \: who \\ \sf\: charge \: a \: fee \: less \: than \: 1500 \mapsto$

⠀⠀

• Select coachname , Gender from club where fees <1500 ;

⠀⠀

$\star \sf \: Display \: details \: for \: only \: swimming \\ \sf\: as \: a \: sport \mapsto$

⠀⠀

• Select * from club where sport = 'swimming' ;

⠀⠀

$\star \sf \: Display \: details \: of \: all \: records \: whose \\ \sf \: \: fees \: are \: in \: between \: 1000 \: and \: 1500 \mapsto \:$

⠀⠀

• select * from club where Fees between 1000 and 1500 ;

⠀⠀

$\star \sf \: Display \: details \: for \: those \: whose \: \\ \sf name \: ends \: with \: "A" \mapsto$

⠀⠀

• Select * from club where coachname like '%a';

⠀⠀

$\star \sf \: Display \: the \: details \: of \: the \: mean \: \\ \sf charge \: more \: than \: +1500 \mapsto$

⠀⠀

• Select * from club where fees > 1500 ;

___________________________

Hope it will help you :)