Based on the following relational schemas, write the SQL commands to answer all the questions given bellow: WORKSHOP (WSCode, WSName, StartDate, StartTime, VenueNum, SpeakerID) VENUE (VenueNum, VenueDesc, VenueLoc, VenueCapacity) SPEAKER (
Based on the following relational schemas, write the SQL commands to answer all the questions given bellow: WORKSHOP (WSCode, WSName, StartDate, StartTime, VenueNum, SpeakerID) VENUE (VenueNum, VenueDesc, VenueLoc, VenueCapacity) SPEAKER (SpeakerID, SPName, SPSex, SPPosition, SPPhone, SPAddress) Note: VenueDesc = venue description, VenueLoc = venue location, SP = speaker
a) Display the names of speakers that name begin with ‘Nurul’ and address in Perak.
b) List workshop details for all workshops that are handled by speaker Dr Nurhaliza Kamil.
c) Using subquery, list venue details for all venues that have not been used for workshop.
d) Calculate how many workshops are handled by speaker Encik Amran Kassim. In output, display speaker’s name and total workshop that he/she handled. Replace calculated column name using TOTAL WORKSHOP.
e) Display the workshop name, start date, venue description and location for all workshops that are run in venue with a capacity greater than and equal to 300. Sort the output according workshop name descending.
f) Display workshop code, workshop name, start date and speaker name for all workshops run in venue located in location starts with letter K.
g) Display details of all male speakers who handle workshops between 21st July 2021 and 21st August 2021.
Step by step
Solved in 2 steps
