Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL! For the following schema, please help me with these 2 queries in SQL: 1. Find the coach(es) (first name and last name) who have

SQL!

For the following schema, please help me with these 2 queries in SQL:

1. Find the coach(es) (first name and last name) who have coached the largest number of players in year 2003

2. List the name(s) of school(s) that sent the second largest number of drafts to NBA. List the name of each school and the number of drafts sent.

image text in transcribed

COACHES SEASON cid ear r_ orderfirstname lastnameseason win season loss playoff win playoff loss tid TEAMS tid location name league PLAYERS ilkid firstname lastname position first season last seasonh feet hinches weigh college birthday PLAYER RS ilkid firstname lastname stl tid league minutes pts dreb oreb asts blk turnoverP Im PLAYER RS CAREER ilkid firstname lastname eague blk minutes pts dreb oreb reb asts turnover p fgm DRAFT draft year draft round selection tid firstname lastname ilkid draftfrom league

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

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions