Answered step by step
Verified Expert Solution
Question
1 Approved Answer
NOTE: Please don't copy your answer from other chegg pages. Much Thanks :) This session we will look at the fundamentals of the SQL Language
NOTE: Please don't copy your answer from other chegg pages. Much Thanks :)
This session we will look at the fundamentals of the SQL Language SELECT command Carry out the following two queries in SQL Developer against the UNI tables (remember you must preface the table name with uni.) Q1. Show the ids, names of students as a single column called NAME and their DOBs. Order the output in date of birth order Q2 Show the ids, names of students as a single column called NAME, unit code, and year and semester of enrolment where the mark is NULL. Order the output by student id, within unit code orderStep 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