Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The query that displays all students registered after the student amal ahmad: Question 7 Not yet answered Marked out of 1.00 P Flag question O
The query that displays all students registered after the student amal ahmad: Question 7 Not yet answered Marked out of 1.00 P Flag question O a. select * from students where REGISTRATION_DATE = (select REGISTRATION_DATE from students where full_name = 'amal ahmad'); O b. select * from students where REGISTRATION_DATE > (select REGISTRATION_DATE from students where full_name = 'amal ahmad'); O c. select id,full_name from students where REGISTRATION_DATE > (select REGISTRATION_DATE from students where full_name = "amal ahmad"); O d. select * from students fjoin students I on(f.id=l.id) where I.full_name like 'amal%'; Question 8 The query that displays number of majors in each department for each faculty: Not yet answered Marked out of 1.00 a. select department_name, count(major_id) from majors group by department_name: b. select faculty .count(major_id) from majors group by faculty, c. select faculty, department_name, count(major_id) from majors group by department_name: d. select faculty, department_name, count(major_id) from majors group by faculty department_name: P Flag
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