Question: 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!

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

(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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

IS3280 Data Management Assignment 5 Course Assignment SQL with One Table Submit via D2L. Please put your name in your file. You can do this assignment in Access. What is required to be turned in is...

mysql questions. All questions are linked. Even if the pictures are blurry please help write the commands for the questions at least QUNSTION: Pandai Sdn Bhd is a company that runs a tuition center...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Assignment2.java ----------------------------------------------------------------------------------------------- import java.sql.*; public class Assignment2 { // A connection to the database...

For how to: https://www.freecodecamp.org/news/how-to-install-mysql-workbench-on-windows/ Take a screen shots of your installation and paste here Watch this tutorial Section on how to use MYSQL work...

Individual Final Project Create A Database System Purpose: To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and...

Consider community safety or defense, meaning freedom from crime and threats, to answer the following questions. a. What sort of good is community safety? b. If you lived in a place with no...

The following bond investment transactions were completed during 2014 by Starks Company: Jan. 31. Purchased 75, $1,000 government bonds at 100 plus 30 days' accrued interest. The bonds pay 6% annual...

1. Read Extract 1 again. As you read, make notes on: of nature the writer gives in the first a. The impression three paragraphs b. Which characters seem 'good' and which 'bad'.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Go to www.ncsu.edu/careerkey, the Web site for Career Key, an assessment tool that can be used for self-assessment and career management. Roll the cursor over Your Personality, and click on...

1. Go to www.thomsonreuters.com, the part of the Web site for the Thomson Corporation that provides career assistance for current Thomson employees and job seekers. Click on Career. What does Thomson...

8. Career management is linked to other human resource practices such as performance management, training, and recruiting systems.