Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

sql file download link: https://drive.google.com/file/d/16mjKAEBJcOI7CbtbwjF_Y63Q7QebZgci/view (3) List the names and emails of all other caretakers (not including the main caretaker) of Bobby Khan. LName I

sql file download link: https://drive.google.com/file/d/16mjKAEBJcOI7CbtbwjF_Y63Q7QebZgci/viewimage text in transcribed

(3) List the names and emails of all other caretakers (not including the main caretaker) of Bobby Khan. LName I EName I Email I Khan Joseph theJKhan@gmail.com I I Khan Jinm I theJKhan2gmail.com (4) List all caretakers (including the main caretakers) of Bobby Khan. I LName EName IEmail I Kan I Aalea l theAKhan@gmail.com 1 I Khan JosephtheJKhangmail.com I I Khan 1 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 title I han Bobby YelloI UHCL OpenI l Khan Bobby Yellow I Shel1 Trial l Johnson I Ciara I Yellow I 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 l Number of Events l Billy Khan | Nina Khan l Philip Johnson I 3 rows in set (0.00 sec) (7) List the names of the swimmers who have participated in both event 3 and event 5 l fname lname I Clara I Johnson I 1 row in set (0.00 sec (8) List the names of all swimmers and their number of wins ('number of times with 'Winner' as results in an event) in the following format. l Swimmer Number of wins l Philip JohnsonI I Bobby Khan I Nina Khan l Biily Khan 5 rows in set (0.00 secl

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced MySQL 8 Discover The Full Potential Of MySQL And Ensure High Performance Of Your Database

Authors: Eric Vanier ,Birju Shah ,Tejaswi Malepati

1st Edition

1788834445, 978-1788834445

More Books

Students also viewed these Databases questions

Question

2. Describe the functions of communication

Answered: 1 week ago