Question: Dears, I have below ER digram, I need the SQL quires for below points: 1- List the matches of the current day. 2- List the

Dears,

I have below ER digram, I need the SQL quires for below points:

Dears, I have below ER digram, I need the SQL quires for

1- List the matches of the current day.

2- List the matches with score of the last journey.

3- List the winners for each journey.

4- Insert the matches of the next journey and the date.

5- List the available stadium with the capacity.

6- List the championship standings.

Name Referee Refio DOB Role Host MatchID Team City Match HostScore GuestScore Date Stadium Name Location

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!