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
Attachments:
Answers
Answered by
121
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;
Equestriadash:
Thank you!
Answered by
120
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 :-
⠀⠀
- Select * from club where Gender = 'F' ;
⠀⠀
⠀⠀
- Select coachname , Gender from club where fees <1500 ;
⠀⠀
⠀⠀
- Select * from club where sport = 'swimming' ;
⠀⠀
⠀⠀
- select * from club where Fees between 1000 and 1500 ;
⠀⠀
⠀⠀
- Select * from club where coachname like '%a';
⠀⠀
⠀⠀
- Select * from club where fees > 1500 ;
___________________________
Hope it will help you :)
Similar questions