Write a single SQL statement to list albums with three columns: the title of the album, the total number of tracks in that album, and the price of the album. Exclude albums that are priced lower than thirty dollars from the output. Rename the column headings appropriately, and sort the output by the price in descending order.

Write a single SQL statement to list albums with three columns: the title of the album, the total number of tracks in that album, and the price of the album. Exclude albums that are priced lower than thirty dollars from the output. Rename the column headings appropriately, and sort the output by the price in descending order.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

Can you Write the SQL statements to do the following please : 1. Display the artist's name from the Artist table in uppercase.2. Display the person's Key, First Name, Last Name and Area Code (first 3 digits of the phone number) from the Person table and label the output as such. 3. Display the current date and five days from that date.4. Display the difference between the current date and the PurchaseDate of the Inventory.5. Display the day of the week, in words, on which the Purchases were place. (Hint: Use datepart dw.)6. Display the minimum, maximum, sum, average, count fields, count records for the SaleDetailPrice from the SaleDetail table. Appropriately label the output.7. Display the count of phone numbers in the Person table.8. Display the record count of the Person table.
Table: Team Member Primary key: Team MemberID Team MemberID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs 1 screen TeamMemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com Duration StartDate Team MemberID 2022-05-06 1 2022-05-15 1 4 10 2022-05-06 2
By using this table answer this question: Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: ‘I’, ‘am’, ‘here’ from the string ‘Where am I?’ and put the three words together using a combination of the CONCAT function and the ||. E.g. The starting string used in the SQL statement is: ‘Where am I?’ The output of the SQL statement after we run it will be: TRANS ---------- I am here
Write an SQL statement to display the last name, first name, and email of all owners who have an email address ending with somewhere.com. Assume that email account names can be any number of characters.
Trying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.
Write the SQL statements using the university schema to perform the followingoperations: Delete all takes tuples corresponding to any section of any course withthe word “advanced” as a part of the title; ignore case when matching theword with the title.
Write SQL statement that prints the intitials (first letter of first name and first lettter or last name name seperated by a space) of all individuals.
Write an SQL statement to change the value of Std. Poodle in BreedName of PET_3 to Poodle, Std
Write the following SQL Statements:1. Write a SELECT statement that returns one row for each customer that has orders with these columns:->The email_address from the Customers table->A count of the number of orders->The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.)->Return only those rows where the customer has more than 1 order.->Sort the result set in descending sequence by the sum of the line item amounts. Q2 7. Write a SELECT statement that returns the name and discount percent of each product that has a unique discount percent. In other words, don’t include products that have the same discount percent as another product.
Write an SQL statement to display the OwnerLastName, OwnerFirstName,PetName, PetType, PetBreed, and AverageLifeExpectancy for pets with a known PetBreed
Write SQL statements for each task:(i) To list the details of equipment (equipment code, name, description, rental rate per day) that cost above $10 to rent per day, with an equipment code that starts with ‘CAM’ and the equipment has been loaned to a customer who is at least 30 years old this year. Give the result in ascending order of the equipment name and rental rate per day. Use subquery.
Write an SQL statement to count the number of pets.