Question: 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/view

(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

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!

As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared...

Database HW help Provide the SQL statements for the following queries. (1) Provide the names and phones of all swimmers currently in level (of id) 3. +-------+---------+---------------------------+ |...

Database HW help!!!!!!! Provide the SQL statements for the following queries. (1) Provide the names and phones of all swimmers currently in level (of id) 3....

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...

Use Tuple Relational Calculus (TRC) to answer the same queries This is the ER Diagram (a) List the names, phones and join times of all swimmers joining CLYSTMS after 1/1/2015 LNameFName Phone l...

Overview: In this assignment, you are given a database and a set of information requests. Use SQL commands to extract the required data, export it , and then apply data visualization techniques to...

World database, Part1 The dataset The world database contains three tables, city, country, and countrylanguage. You can see the schema of the tables in their instantiation below. If you'd like to...

So here is my programming code question in python, what would be the code to answer this question? We regularly hear in the media terms like the Silver Tsunami referring the fact that as time...

Project 3: Decision Trees You are going to implement the ID3 algorithm to classify adults into two income brackets . Each line of the file looks like this: workclass, education, marital-status,...

Solve it in Microsoft SQL Server 2016 Get your SQL file against Link: https://raw.githubusercontent.com/microsoft/sql-server-samples/master/samples/databases/northwind-pubs/instnwnd.sql Copy...

Write a MATLAB code to read each frame of the video file dot.mp3 (video file download link: https://www.filemail.com/d/yvfpwlbyvykuafa, assuming dots are in a pipe) and: 1. Find the location of the 2...

What should public relations people know about the regulations of the Federal Trade Commission? The Securities and Exchange Commission?

The final paper will present an issue that a manager of your chosen company (Google) may face. You can select from the following list of issues: You discover that one of your management team has been...

Define the going concern assumption and explain its impact on preparing the financial report

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. Effectively communicating benefits to employees is an ongoing concern for HR professionals. Employers are relying more on technology and social media to spread the good news to employees about the...

1. Benefits are being used to build a sustained competitive advantage and ultimately satisfy a companys strategic objectives. Employers that offer generous benefit packages are often viewed as model...

2. The costs associated with providing desirable benefits are increasing at a steady rate. This reality challenges companies to offer competitive benefits and also keep a close eye on the bottom line.