Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q3) SQL a) given the Course table below [15 marks) CNum CName 210 Database 314 Privacy 101 English 132 Math 115 Biology 3 4 2
Q3) SQL a) given the Course table below [15 marks) CNum CName 210 Database 314 Privacy 101 English 132 Math 115 Biology 3 4 2 3 3 (5 marks) CNumof Hours CRegDate 01-09-2021 05-09-2021 14-09-2021 20-09-2021 29-09-2021 Write an SQL Query to: (1) insert the first two tuples of the Course table (2) retrieve all columns of the Course table (3) retrieve all columns with the highest CNumofHour (using Max function) (4) retrieve the CNum, CName columns where the CRegDate is after 17-09-2021 (5) retrieve CNum column sorted in ascending order by CNumofHours
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started