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

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
Write an SQL statement to display the name and breed of all pets, sorted by PetName.
Write an SQL statement to display the name, breed, and type for all pets that are not of type Cat, Dog, or Fish.
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 a SQL statement that returns a list of the team members with all their tasks. Include the team member’s name and the description of the task in the results.
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.
Write an SQL statement to display the pet ID, breed, and type for all pets having a four-character name starting with K.
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 any owners of cats with the name Teddy. Use a subquery
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 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.
From the Salesman and Customer tables below, write SQL statements to do the following: List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character. List the name and country of those customers and salesmen who belongs to the same country. Salesman table: Customer table: