I demand 5 out of the 7 SQL questions retorted. The table is uploaded to retort the qustions.
The problems underneath are for the earliest dismanage continuity in Week 2.
1. Create a SQL interrogation that extracts all functions and the manages that are among that function. Direct the facts by program in ascending direct.
2. Create a interrogation that catalogues all novices’ definite indicates and earliest indicates, the denomination of the program they are pursuing, the estimate of reputations they entertain, and the whole required reputations for the program. Direct the catalogue by Novice Lastindicate in descending direct.
3. Create a catalogue that shows each manage principle, manage denomination, and noviceID, parallel delay the novice's indication in that manage. You do not entertain to catalogue the novice's indicate. Direct the facts by manage denomination in ascending direct.
4. Show all manage IDs for a novice indicated Jose Ramirez. Include Jose’s definite indicate, earliest indicate, and proceeding in each manage.
5. Create a catalogue of novices and the programs they are pursuing. Catalogue singly those novices whose estimate of reputations is close than the required reputations in their program.
6. Show a catalogue of all manages, their reputation hours, and denominations of their functions.
7. Show a catalogue of all manages, their reputation hours, and denominations of their functions. Include singly those manages whose manage principle starts delay an M.