QUESTION 15 use the follwoing picture to answer the question Write a select statement which should display the ITEM_SIZE, COLOR, CURR_PRICE of ORDERID = 1058. (you need to join the tables)
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: Complex queries 23. Select the courses which are taught in the Taylor building in Spring 2018. (See…
A: SQL queries for the above questions given below where SELECT statement is used to display, to sort…
Q: 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with 'et' and…
A: Given table:
Q: nt that
A: The explicit join syntax makes use of two keywords, ON and JOIN. ON keyword is used to specify the…
Q: Add a column named ON_HAND_VALUE to the NONCAT table. The on-hand value is a seven-digit number with…
A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…
Q: To select the category from listbox1 when the item selected from listbox1 the item of the category…
A: To select the category from listbox1 when the item selected from listbox1 the item of the category…
Q: Use LargeCO tables to complete this assignment. Write a stored procedure that adds a new employee…
A: Actually, database is used to stores the data.
Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…
A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…
Q: please use the picture below to answer the following question Display employee number, employee…
A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…
Q: The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field…
A: - The question is to delete the column DRIVER_DRIVING_LICENSE_CHECKED as there is no need of it. -…
Q: Assume you need to create a table that contains a column called CreditLimit. Which of the following…
A: In the given question, queries have two types of options that includes: ADD(): In SQL, the command…
Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…
A: As per guidelines we are supposed to answer only first 3-sub parts at time. please repost the…
Q: 4.8 LAB - Select movie ratings with left join The Movie table has the following columns: ID -…
A: The LEFT JOIN keyword returns all records from the left table and the matching records from the…
Q: Create a sequence according to following criteria: • Create an ascending sequence called id_seq,…
A: The sequence in the database management system is a group of numbers or integers such as 1, 2,... so…
Q: Q1) Please write. a query statement from emp table to display deptno 10’s empno, ename, sal, and a…
A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…
Q: To change a primary key in table you should do the followings: use the ALTER TABLE to drop the…
A:
Q: Create table customer1( Customer# number primary key, First_name varchar2(25, Last_name…
A: Please find the answer below :
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: Select number of movies grouped by year USING MySQL The Movie table has the following columns:…
A: Answer: Given table name is Movie Select statement is used to print the required fields on the…
Q: What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box…
A: Query builder: The query builder is used to construct the SQL (Structured Query Language)…
Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…
A: select * from Magazine where Name like 'Visual Basic';
Q: 10-Create a products table that has product id, product name, and price fields. Write a query to…
A: Algorithm : 1) Create the table products. 2) Insert some values in the table. (I have added 4…
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: 1- Display contact First name and contact Last name for customers after sorting the customers by…
A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…
Q: When creating a SQL table, _____. a. include only those columns for which data will always be known…
A: Ans: When creating a SQL table, d) you must add PRIMARY KEY NOT NULL for the primary key column(s)
Q: List the owner number and last name for all owners located in the city of Seattle. Your query should…
A: Since no name is given so i am assuming the name of the table is OWNER
Q: Delete rows from Horse table The Horse table has the following columns: ID - integer, auto…
A: Please find the answer below :
Q: The InstantRide Finance team also wants to analyze travels where more than the average discount rate…
A: Since you have not specified the table name , let us assume that the data is present in TRAVELS…
Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…
A: As per the requirement submitted above , kindly find the below solution.
Q: The Horse table has the following columns: • ID - integer, primary key RegisteredName -…
A: SQL query : SELECT RegisteredName, Height FROM Horse where Height> (SELECT AVG(Height) FROM…
Q: Add validation on CTYPE column in CUSTOMERS table. It must accept either ‘New’ or ‘Old’ only
A: SQL Command to add validation in CTYPE attribute of the table CUSTOMERS is: ALTER TABLE CUSTOMERS…
Q: OrderlD item quantity 1 Fahita 1 Menu 1 Pepsi Item type price 1 Shawarma 2 Соса Drink 1.5 1 Water…
A: The correct answer is given below:
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 Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…
A: Solution: Write a SQL SELECT statement that selects only the Name and Cost fields from records…
Q: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…
A: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…
Q: 1. Please write SQL codes to query data from dvd table based on below criteria Please write a…
A: To match a range of letters SQL provides an operator called REGEXP_LIKE where we need to mention the…
Q: use the picture below to answer the following question Add a ZIP field/column to the customer…
A: Add a column in the table You can use the ALTER TABLE statement in SQL Server to add a column to a…
Q: Using the sp_InsertTeamDetails (check link above) procedure, create a query to insert the following…
A: The table is given below:-
Q: The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName…
A: The INSERT INTO statement is used to insert new records in a table. There two ways to write the…
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: Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length…
A: Height should be between 15.0 and 16.0 (inclusive) . For this we will write Height >= '15.0' AND…
Q: Orderltem OrderID item quantity 1 Fahita Menu 1 Pepsi Item type price 1 Shawarma Coca Drink 1.5 1…
A: Below is the answer of both questions. I hope this will be helpful for.
Q: Which SELECT statement retrieves the customer name for those that have a salesperson number of 137?…
A: Here, we have to choose the options for the above problem. Given , customer table with the fields…
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: Select all rows from the Orders table where the CustomerID is greater than 300.
A: Syntax: SELECT column1, column2, ...FROM table_nameWHERE condition;
Q: Please write the final answer in the following answer table. question 1 question 2 question 3…
A: The answer as given below:
QUESTION 15
use the follwoing picture to answer the question
-
Write a select statement which should display the ITEM_SIZE, COLOR, CURR_PRICE of ORDERID = 1058. (you need to join the tables)
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…The pg2.np_2016traffic table contains monthly traffic statistics from the National Park Service for parks. Create a table using sas programming language that contains the monthly traffic statistics from the pg2.np_2016traffic table and adds a column for the park name. Park name values can be found in the matching pg2.np_codelookup table.Create a trigger named trg_line_prod that will automatically update the product quantityon hand for each product sold after a new LINE row is added. Output:After inserting a new row in to LINE: Before running the Trigger the P_QOH was 23: After running the Trigger the P_QOH was 21:
- 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…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.44The command DESC DEPARTMENTS shows the following information Name Null? Туре DEPARTMENT_ID NOT NULL NUMBER (4) DEPARTMENT NAME NOT NULL VARCHAR2 (30) MANAGER ID NUMBER (6) LOCATION_ID NUMBER (4) Which of the following is correct This table has a primary key. This table has a foreign key. This table has both primary and foreign keys. This table has neither primary nor foreign keys. Not enough information to answer. 10 points
- Products dataset contalns Price column. Which of the following is the correct way to Increase the ticket price by 7%? Select one: O summarise(Products , Price = Price * 0.07) O mutate(Products , Price = Price + Price 0.07) O mutate(Products, Price = Price 0.07) O summarise(Products , Price = Price + Price • 0.07)CONSIDER THE INVOICE TABLE BELOW: invoice id NUMBER (12), invoice date DATE,Invoice total NUMBER (9, 2), payzent_total NUBER (9, 2), credit total NUMBER (9, 2),invoice due date DATE, payrent date DATE,CIL REC user VARCHAR2 (12),CTL SEC level NUMBER (1)Consider the INVOICE table structure below: A trigger is created on the INVOICE table: CREATE OR REPLACE TRIGGER rg_On_Quiz before insert or update on Invoice FOR EACH ROW DECLARE V_level Number; V_name VARCHAR (20); Begin SELECT USERNAME, SECURITY_LEVEL INTO V_name, V_level FROM AUTHORIZED_USERS WHERE USERNAME = USER; :NEW.CTL_REC_user := V_name; :NEW.CTL_REC_user := V_level; EXCEPTION WHEN NO_DATA_FOUND THEN RAISE_APPLICATION_ERROR (-2003, 'UNAUTHORIZED USER'); END; In Oracle/PLSQL, the USER function returns the user_id from the current Oracle session. a.) Explain what this triger does…insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size. mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname | city | +---------+---------------+--------+ | ch01 | Omni Shoreham | London | | ch02 | Phoenix Park | London | | dc01 | Latham | Berlin | | fb01 | Grosvenor | London | | fb02 | Watergate | Paris | +---------+---------------+--------+ mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type | price | +--------+---------+--------+-------+ | 501 | fb01 | single | 19.00 | | 601 | fb01 | double | 29.00 | | 701 | ch02 | single | 10.00 | | 701 | fb01 | family | 39.00 | | 801 | ch02 | double | 15.00 | | 901 | dc01 | single | 18.00 | | 1001 | ch01 | single | 29.99 | | 1001 | dc01 | double | 30.00 | | 1001 | fb02…
- 8. Create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows: CREATE TABLE ShippingLabels (VendorName varchar(50), VendorAddress1 varchar(50), VendorAddress2 varchar(50), VendorCity VendorState VendorZipCode varchar(50), char(2), varchar(20)); Use this UPDATE statement to test the trigger: UPDATE Invoices SET PaymentTotal = 67.92, PaymentDate = '2020-02-23' WHERE InvoiceID = 100;use drracket. intermediate studentCode. Request.