The InstantRide Finance team also wants to analyze travels where more than the average discount rate is applied. They want to look for any correlation between higher discount amounts against other travel characteristics. You need to create a SELECT statement which is filtered with a subquery to calculate the AVG of the TRAVEL_DISCOUNT column.
Q: Write a SELECT statement that returns the companyname, address, city and postalcode from the…
A: We need to display companyname, address, city and postalcode from the suppliers table Tables needed:…
Q: The team wants to track potential list of users who may have forgotten their items on the cars.…
A: SELECT U.USER_FIRST_NAME, U.USER_LAST_NAME, T.TRAVEL_START_TIME, T.TRAVEL_END_TIME FROM USERS U…
Q: Display the RID, RType and Bedroom of all ROOMS whose number of bedrooms is less than RID 105. Use…
A: Required:
Q: Create your own format of the market list to include, name of items or supplies that are used…
A: import java.util.ArrayList; import java.util.List; import java.util.Scanner; class Product { //…
Q: Colombia office employees started using COLOMBIA_CITY_PROPERTY and they want to update the rent of…
A: the query is given below :-
Q: Display all customers regardless of orders and also display orders for each customer.
A: Query to display all the customers that have placed an order and those that have not placed the…
Q: The InstantRide Driver Relationship team wants to check if there are any drivers with zero rides.…
A: We need to have two tables. One with the Travel details and other with the Driver details. We are…
Q: Which line of the SELECT statement is used to restrict groups displayed in the query results?…
A: Select statement The select statement is used to select data from a database. The data returned is…
Q: The InstantRide Driver Relationship team wants to check if there are any drivers with zero rides.…
A: As per the given information, we are having two tables to play with: 1. DRIVERS 2. TRAVELS The…
Q: Create a row level trigger which insert a tuple into the customner_audit (customerNO, customerName,…
A: Customer Order tables: Customer (customerNO, customerName, address, city, category, custBalance)…
Q: Which of the following commands will increase the size of the CITY column in the CUSTOMERS table
A: ALTER command: In Structure Query Language (SQL) the ALTER command is used to add, modify or…
Q: Which tuples with null values for the title property are included in the query select * from student…
A: Given is a query select * from student natural full outer join and we need to tell the condition for…
Q: Create and test a stored procedure that uses the CompetitorCountry view that allows one to pass in…
A: create procedure select_athletes @CountryCode nvarchar2(10) as select * from CompetitorCountry where…
Q: Part II: Complete the following exercise: Using a subquery, select student first name where the…
A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…
Q: How do you create a primary key for a table with columns that could potentially contain the same…
A: A primary key must be the column with all different values. In some tables a single column may not…
Q: 5. For each order, list the order number, quoted price and the item description, when the category…
A: 5. To get the required results, we need to use ORDERS, OPRDERLINE, ITEM tables Query: SELECT…
Q: Rewrite the query to be more specific. choose * from the natural section and then join the…
A: In SQL query, natural join is a type of equi joins constructed so that columns from related tables…
Q: Your manager requires you to create an SQL query that will display the combined customer name, the…
A: SQL query to select customer name ,townhouse number ,material and purchase amount ,in which purchase…
Q: Products dataset contalns Price column. Which of the following is the correct way to increase the…
A: Data sets are the collection of data in tabular forms and it corresponds to data from many database…
Q: Company also likes to find out the total purchase amount and the number of transactions made by each…
A: Please find the answer in step 2.
Q: dd a Varchar Color (15) field with constraint not null to the shoe tabl
A: The given problem is related to database SQL queries where the requirement is to update the table.
Q: What will be the field size for the ProductLineName field in the Product table? Why?
A: The field size is 40.
Q: The query to join the P_DESCRIPT and P_PRICE columns from the PRODUCT table and the V_NAME,…
A: Given: The query to join the P_DESCRIPT and P_PRICE columns from the PRODUCT table and the V_NAME,…
Q: Using subquery, display city and remainder of location_id by dividing 3 with the column name…
A: Subquery is a query written inside a query which further used for filtering
Q: CREATE TABLE product ( product_id NUMBER(3) PRIMARY KEY, product_name VARCHAR(30) NOT NULL, price…
A:
Q: Create a query based on tblEmployee and tblPurchase using the Find Unmatched Query Wizard that lists…
A: Answer: First, Create a table with data. Click Query wizard Choose to Find unmatched query wizard…
Q: Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the…
A: According to the Question below the Solution :
Q: Create a list of all book titles and costs. Precede each book’s cost with asterisks so that the…
A: A function is a self-contained block of statements. A function can take one or more parameters and…
Q: Please write a query statement from emp table to display ename, sal, and sal_star for all employees.…
A: Hey there , I am writing the required solution for the above stated question. Please do read the…
Q: Generate a listing of all purchases made by the customers, using the output shown below as your…
A: To list, purchase table in sorted order we can use order by clause. Syntax of the ORDER BY clause…
Q: Which clause do you add to the following SELECT statement to limit the display to those categories…
A: SELECT catagory_id, SUM(price) FROM products GROUP by catagoriy_id a. HAVING SUM(price)<5000 or…
Q: The InstantRide User Satisfaction team requires the average and maximum number of rides users have…
A: SELECT USER_ID, COUNT(TRAVEL_ID) AS CNTFROM TRAVELSGROUP BY…
Q: I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES…
A: Answer in step 2
Q: You want to use the summarize() and max() functions to find the maximum rating for your data. Add…
A: Note: As you had not provided any information about any particular data set . we have provide a…
Q: What’s the purpose of a column qualifier? When are you required to use one?
A: 1. Column qualifiers are used for distinct access of the data values in order to identify them…
Q: Go to the Scores by Date worksheet. In cell A3, insert another PivotTable based on the Calls table.…
A: Here is the solution to the abov problem :- Step 1 Select the table from A4:J143 Step 2 Insert…
Q: Insert a row into the LARGE_PROPERTY table for a new property. The office number is 1, The address…
A: Use the INSERT INTO statement to insert new records in a table.
Q: Given the query below in green text, rewrite it to make it more readable and easy to maintain using…
A: we have to make changes to above query
Q: JQUERY to Animates all divs to slide down and slide up.
A: Given, We have to create a JQUERY to animate all 'divs' to slide down and slide up.
Q: The InstantRide Finance team wants to collect the price and discount information with the driver…
A: The following SQL command is
Q: write a query to find the last_name that is 4th from the bottom using subquery. (you need to use…
A: In SQL, to select the specific number of records SELECT TOP clause is used. To get the record from…
The InstantRide Finance team also wants to analyze travels where more than the average discount rate is applied. They want to look for any correlation between higher discount amounts against other travel characteristics. You need to create a SELECT statement which is filtered with a subquery to calculate the AVG of the TRAVEL_DISCOUNT column.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…Estem.org/courses/64525/assignments/9460783?module_item_id=18078917 The following information can help you get started: • Invitation Details: it boils down to when and where o When: Time and date • Where: Address • Invitee List: Name and email • Name: First Name, or First Name and Last Name Email: Email address . Other considerations: After you complete your invitation, answer the following questions: 1. What type of data are time, date, and place? How are they different from the other data types on the invite and guest list? F4 A Additional information worth including: dress code, directions, gifting, how to contact you. . How will you know who is showing up? RSVP? . Is there a theme to your invitation/design? x F5 % F6 F7 DELL F8 F9 ROMNA F10 F11 PrtScr
- Given the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees…Apply the First Normal Form (1NF) and Second Normal Form (2NF) steps to the following two tables. ST_ID ST_Name ST_Major St_Phone ST_Email 100 Marla jen ACCT (703) 111-2222 mjen@gmail.com 110 Jan Bok MGMT (703) 222-3333 jbok@verizon.net 115 Lee Chan MIS (703) 333-4444 (703) 444-5555 lchan@cox.net Table 1 ID Name Courses 1 Ashely Key MIS 302, MIS 303 2 Katy Pery MIS 310 3 Mickey Zen MIS 303, MIS 350 Table 2The data in flat files has been provided: INVOICE TABLE INVOICE_NUM CUSTOMER_ID INVOICE_DATE EMPLOYEE_ID COIN_ID DELIVERY_ID 8111 11011 15 May 2021 emp103 7111 511 8112 11013 15 May 2021 emp101 7116 512 8113 11012 17 May 2021 emp101 7112 513 8114 11015 17 May 2021 emp102 7111 514 8115 11011 17 May 2021 emp102 7115 515 8116 11015 18 May 2021 emp103 7115 516 8117 11012 19 May 2021 emp105 7112 517 8118 11013 19 May 2021 emp105 7112 517 COIN_RETURNS TABLE RETURN_ID RETURN_DATE REASON CUSTOMER_ID COIN_ID EMPLOYEE_ID ret001 25 May 2021 Customer not satisfied with product 11011 7116 emp101 ret002 25 May 2021 Product missing part 11013 7114 emp103 COIN TABLE COIN_ID PRODUCT PRICE QTY 7111 1oz Gold Kruger Rand R 5 999 10 7112 1oz Silver Kruger Rand R 12 999 8 7113 Gold Big 5 Uncirculated R 15 999 8 7114 Silver Big 5 Pack R 7 999 5 7115 1oz Gold Palaeontology R 11 999 15 7116 1oz Silver Palaeontology R 7 999 12 COIN_DELIVERY TABLE…
- Populate the CUST_NUM, INV_DATE, and INV_AMOUNT fields with the following customers: CUST_NUM INV_DATE INV_AMOUNT 1000 2016-03-23 235.89 1001 2016-03-23 312.82 1001 2016-03-30 528.10 1000 2016-04-12 194.78 1000 2016-04-23 619.44Q3/Consider the following table is used to truck information: Truck_num Base_code Base_city Base_state Type_code Truck_serial_num 1001 501 Dalton GA 1 AA-332-W11 1002 502 Lexington KY 1 AC-342-023 1003 501 Dalton GA 2 AC-445-799 1004 503 Murfree TN 1 WQ-112-T34 1005 503 Murfree TN 2 FR-998-W12 The table is considered as not normalized, explain why? And what is the INF of the table?The table VideoVisitFact has a single primary key column of VideoVisitKey. The column is numeric. Which of the following returns the number of rows in the VideoVisitFact table? A. SELECT MAX (VideoVisitKey) FROM VideoVisitFact B. SELECT COUNT (*) FROM VideoVisitFact C. SELECT (*) FROM VideoVisitFact D. SELECT SUM(VideoVisitKey) FROM VideoVisitFact
- Link of the procedure: https://www.bartleby.com/questions-and-answers/computer-engineering-question/110b20bb-9fc9-44d7-885d-c28ed9f41bf7 Using the sp_InsertTeamDetails (check link above) procedure, create a query to insert the following values into the Rugby_world_cup table. Team_id Team_name Country Tries Conversions Drop_Goals Points 10 The Brave Blossoms Japan 4 3 1 35 12 Wallabies Australia 14 7 1 93 14 Welwitschias Namibia 4 3 3 44 16 Springboks South Africa 10 5 1 78 18 The Bati Fiji 2 1 1 24INVOICE VEND_ QUANT_ PROD_ INV_NUM PROD_NUM SALE_DATE PROD_LABEL VEND_NAME CODE SOLD PRICE 211347 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. 1 $49.95 211347 QD-300932X 15-JAN-2016 0.25-in. drill bit 211 Neverfail, Inc. 8 $3.45 211347 RU-995748G 15-JAN-2016 Band saw 309 BeGood, Inc. 1 $39.99 211348 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. $49.95 211349 GH-778345P 16-JAN-2016 Power drill 157 ToughGo, Inc. 1 $87.75MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...