Assistance needed with SQL commands
Assistance needed with SQL commands
Assistance needed with SQL commands
I need assistance with the query commands assigned to an assignment. I have the databases properly created and do not need assistance with the commands associated with creating the databases. Here is the complete assignment. I have attached the database information.
DIRNUB
, DIRNAME, DIRBORN, YR-DIRDIED)
STARNUB
, STARNAME, BIRTHPLACE, STARBORN, YR-STARDIED)
MVNUB
, MVTITLE, YRMDE, MVTYPE, CRIT, MPAA, NOMINATIONS, AWRD,
DIRNUB
)
MVNUB
,
STARNUB
, AMTPAID)
MMBNUB
, MMBNAME, MMBADD, MMBCITY, MMBST, NUMRENT, BONUS, JOINDATE)
TAPENUM,
MVNUB, PURDATE, TMSRNT,
MMBNUB
)
:
- ** List the names and numbers of directors whose names begin with the alphabet ‘K’.
- List the tape no, movie title, and the membership number and name of members, who are currently borrowing tapes numbered below 20. Arrange the report in descending order by tape number.
- List the names and respective numbers of stars and directors who have worked together.
- ** List the tape numbers for movies of movie type: ‘HORROR’.
- List the name of the director who has received the maximum number of total awards considering all his/her movies: AWRD.
- ** List the names of all members who have not borrowed any movie currently.
- List the movie type and number of tapes for each type in the database.
- ** For each movie list total how many times it has been rented: TMSRNT.
- Report the total times rented (TMSRNT) for each movie type.
- The database administrator discovers that the name of director whose number is 7 in the database should be spelt as ‘JOHNNY FORD’. Make corrections to the data.
- Delete the movie number 14 and all its tapes. Print both tables to verify.
- List all tape numbers and their movie titles, and indicate the member number and member name if the tape is currently rented out.
13. List all tape numbers, and also indicate the member’s city if a tape is currently rented out by a member.
How many movies did he/she direct?