1. Write the sql statement that will provide you a list of all actors names sort
ID: 3590622 • Letter: 1
Question
1. Write the sql statement that will provide you a list of all actors names sorted by last name, then by first name. (Without 2. Write the sql statement that will provide you a list all films rated R and include the record count. (Without using the 3. Write the sql statement that will provide you a list all films that are category "Action" and include the record count. 4. Write the sql statement that will provide you a list all films that have the string "SIDE" in their name and include the record 5. Write the sql statement that will provide you with just the count of films under 90 minutes and include the record count using the wildcard () for the fields.) wildcard ( for the fields.) (Without using the wildcard() for the fields.) count. (Without using the wildcard ( for the fields.) and the film count. (Without using the wildcard (*) for the fields.)Explanation / Answer
Following are your queueries based on the assumed table and colum names, please provide more information of database schema objects if you need a more clear answer. I will update my answer based on your feedback if required.
1. select actor_names from actors order by last_name ASC, first_name DESC;
2. Select COLUMN_NAME from USER_TAB_COLUMNS where TABLE_NAME = 'FILMS'; -----(assuming the table you are querying is 'FILMS')
select film_name, film_year from FILMS where film_rating = 'R';
select count(*) from FILMS where film_rating = 'R';
3. select film_name, count(*) from FILMS where category = 'Action';
4. select film_name, count(*) from FILMS where film_name like '%SIDE%';
5. select film_name from FILM where duration < 90
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.