Write SQL statements that will perform the following. 1. Select all the unique values from the Album column in the Artists table. 2. From the Regions table, select all rows where the Province column has the value 'Rizal'. 3. Select all records from the Artists table and sort the result reversed alphabetically by the column Album. 4. In the Regions table, set the values of the Municipality column to 'Cainta', but only the ones where the Province column has the value 'Rizal'. 5. From the Regions table, select all records where the value of the Province column starts with 'L' and ends with 'a'.

Write SQL statements that will perform the following. 1. Select all the unique values from the Album column in the Artists table. 2. From the Regions table, select all rows where the Province column has the value 'Rizal'. 3. Select all records from the Artists table and sort the result reversed alphabetically by the column Album. 4. In the Regions table, set the values of the Municipality column to 'Cainta', but only the ones where the Province column has the value 'Rizal'. 5. From the Regions table, select all records where the value of the Province column starts with 'L' and ends with 'a'.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

Q: Write a SELECT statement that returns two columns based on the Vendors table. The first column,…

Q: Complete the SQL statement to generate the Result table. The column names in the SELECT clause must…

A: SELECT Order.OrderCode, Part.PartName, Order.PartNumberSELECT: This keyword is used to specify the…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write SQL statements to list the name of Lee’s subordinate employee. (Data Update) Write…

A: Lees Employee ID is 2 So, to get the lees subordinate then we need to search for this employee ID in…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: Write all the sql code (including create, insert and select)

A: #use the below query to create users tablecreate table users(account int primary key,name…

Q: Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the…

A: SELECT CONCAT(LastName," ",substring(FirstName,1,1)) as CONTACT, HomePhone as Phone FROM EMPLOYEES…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Students Table : • List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to…

A: ANSWER: Student Table: Syntax of SQL Table Statement

Q: In the preceding PL/SQL block, determine the values and data types for each of the following cases.…

A: PL/SQL block, the values and data types for each of the following cases are: a) The value of…

Q: Write a SQL Query that uses the annual growth to get a projection for total population for the years…

A: Given tables are: table_1: CountryName, Year, AnnualGrowth, CumulativeGrowth table_2:CountryName,…

Q: From the Salesman and Customer tables below, write SQL statements to do th following: a) List the…

A: Actually, SQL stands for Structured Query Language.

Q: The given SQL creates a Song table and inserts three songs. Write three UPDATE statements to make…

A: Solution - (Note: all data used in this solution is dummy.) Song table at starting - Task 1:…

Q: Write an SQL Query to list the name(s) and address(es) of employees who work at the department…

A: The solution is written in SQL. Please check the solution in the next step. Note: As per the…

Q: List all the names of the production companies and all the movie titles, all together in one single…

A: Since no sample table and data is provided, I have created two tables, movie and producer. Then I…

Q: List only the movies that have a value for gross (not NULL values). Include all columns in the…

A: The SQL query you provided is used to retrieve data from the "movies" table. The query selects…

Q: SQL where you are searching for the most common value in one column for a specific value from…

A: A SQL query is a command used to request data from tables stored in relational databases. In…

Question

Write SQL statements that will perform the following.
1. Select all the unique values from the Album
column in the Artists table.
2. From the Regions table, select all rows where the
Province column has the value 'Rizal'.
3. Select all records from the Artists table and sort
the result reversed alphabetically by the
column Album.
4. In the Regions table, set the values of the
Municipality column to 'Cainta', but only the
ones where the Province column has the
value 'Rizal'.
5. From the Regions table, select all records where
the value of the Province column starts with
'L' and ends with 'a'.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

How do I do this question in SQL command? Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.
You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.
8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands
#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after 1992. The second SELECT statement selects the release year for song with ID 800. Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery. The ORDER BY clause should appear after the subquery. Run your solution and verify the new query returns a result table with five rows, all with release years after 1992. CREATE TABLE Song (ID INT,Title VARCHAR(60),Artist VARCHAR(60),ReleaseYear INT,Genre VARCHAR(20),PRIMARY KEY (ID)); INSERT INTO Song VALUES(100, 'Hey Jude', 'Beatles', 1968, 'pop rock'),(200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'),(300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'),(400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'),(500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'),(600, 'That\'s…
SQL Server Please help answer question 5 Please type out the answer because I cannot read the last answer because the handwriting is not very clear. Thank you.
Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345