Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

More Books

Students also viewed these Databases questions