Find the album title, band name, format, and total length of all albums. Order from longest to shortest.

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'

The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending). Hint: Use a subquery to find the average height.

List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.

You will be using the Colonial Adventure Tours database. Find the trip name of all reservations for hiking trips and sort the results by trip name in ascending order.

4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null.

If a column value is NULL, would you consider the column to be 0 or blank (" ")?

StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task   Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.

DONT COPY FROM CHEGG == REPORT + DISLIKE 9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first)

Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians.       CREATE TABLE Movie (  ID INT AUTO_INCREMENT,  Title VARCHAR(100),  Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')),  ReleaseDate DATE,  PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES  ('Casablanca', 'PG', '1943-01-23'),  ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'),  ('The Dark Knight', 'PG-13', '2008-07-18'),  ('Hidden Figures', 'PG', '2017-01-06'),  ('Toy Story', 'G', '1995-11-22'),  ('Rocky', 'PG', '1976-11-21'),  ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';