Question: SQL Query 1. Write a query to display the city and country where an office is located and the first and last name of employees

SQL

Query 1. Write a query to display the city and country where an office is located and the first and last name of employees (in 1 column) at that loca3on. Order the results in reverse alphabe3cal order.

Query 2. List the orderNumber, the name of the products on the order if the product is a type of car. Order the results in ascending order of the order number.

Query 3. Write a query to list out the product name and the percentage discount on each product. Provide the result with a % sign and order the results in the descending order of the discount.

Query 4. Write a query to count the number of orders whose status is Shipped for customers from France whose credit limit is greater than 100000.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SQL ClassicModels Database Query 1. Write a query to display the city and country where an office is located and the first and last name of employees (in 1 column) at that loca3on. Order the results...

please help all of this is in SQL CSCI 3300 DEM01 Project I Use the hr database 1. Write a query to display the names (first_name, last_name) using alias name "First Name", "Last Name". 2. Write a...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

Write a query to display the city and country where an office is located and a count of the number of employees at that location. Order the results in descending order of the number of employees. a....

6 SQL Query questions: Write a query to display an invoice for order 693 including the title, quanty, price, and a calculated column to display the line item subtotal (quantity times price) with a...

SQL Please. 1. Write a query using JOINS to list the orderid, orderdate, customer last name, customer first name for any orders made with a sales rep with the last name of JONES (use all caps). 2....

Q11 (10 pts) Write SQL to create a table called City in your account. The schema of the table is listed below. You must define the data types and not null constraint (if needed) of every column and...

Table: EMP_NUM EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB EMP_HIRE_DATE EMP_AREACODE EMP_PHONE EMP_MGR 100 Kolmycz George 15-JUN-42 15-MAR-85 615 324-5456 101 Ms. Lewis Rhonda 19-MAR-65...

DUMBA Bank has granted you a 7-year loan of $50,000. Your first of seven annual payments of $12,600 is due 1 year from today. What rate of interest is DUMBA charging?

You are the defendant in a highly publicized trial about race discrimination. The plaintiff began presenting her evidence at trial. Your lawyer made a motion to exclude an important witness of the...

The objectives are: ( 1 ) keep the cost below $ 8 0 0 , 0 0 0 / week and ( 2 ) to not produce excess ore. Formulate the problem ( no need to solve ) to find the number of days / week each mine should...

in operating systems, what would make you select one short term scheduling algorithm over another? please send it to mirre06@hotmail.com thanks

KEY QUESTION What is the formula for measuring the price elasticity of supply? Suppose the price of apples goes up from $20 to $22 a box. In direct response, Goldsboro Farms supplies 1200 boxes of...

How is the $10 best allocated between A and B? How much utility will the marginal dollar yield?

Assume that the banking system initially has no excess reserves and that the reserve requirement is 10 percent. Also assume that velocity is constant and that the economy initially is operating at...