Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DATABASE QUESTION: SQL/MYSQL Following are the relation and their attributes. Can you provide the SQL queries for the following questions? I will big thumbs up
DATABASE QUESTION: SQL/MYSQL
Following are the relation and their attributes. Can you provide the SQL queries for the following questions? I will big thumbs up you!
(4) List all caretakers (including the main caretakers) of Bobby Khan I LName I FName Email I Khan Azalea theAKhan@gmail.com I I Khan I Joseph theJKhan@gmail.com I Khan JimtheJKhan2@gmail.com (5) List all swimmers (their names, levels and event titles), and the meet titles in which the swimmers have participated in an '200M Freestyle' event of the meet I LName FName | level I title I Khan Bobby | Yellow I UHCL Open | Khan I Johnson I Clara Yellow| Shell Trial I I Bobby I Yellow | Shell Trial I (6) List the swimmers (names and their number of participated events) who have participated in two or more '50M' events (events with '50M' in their titles) in the following format. l Swimmer | Number of Events | Billy Khan | Nina Khan l Philip Johnson | 3 rows in set (0.00 sec) (4) List all caretakers (including the main caretakers) of Bobby Khan I LName I FName Email I Khan Azalea theAKhan@gmail.com I I Khan I Joseph theJKhan@gmail.com I Khan JimtheJKhan2@gmail.com (5) List all swimmers (their names, levels and event titles), and the meet titles in which the swimmers have participated in an '200M Freestyle' event of the meet I LName FName | level I title I Khan Bobby | Yellow I UHCL Open | Khan I Johnson I Clara Yellow| Shell Trial I I Bobby I Yellow | Shell Trial I (6) List the swimmers (names and their number of participated events) who have participated in two or more '50M' events (events with '50M' in their titles) in the following format. l Swimmer | Number of Events | Billy Khan | Nina Khan l Philip Johnson | 3 rows in set (0.00 sec)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started