1. Write a SELECT statement that returns four columns based on the Invoice To column of the Invoices table: • Use the CAST function to return the first column as data type decimal with 2 digits to the right of the decimal point. • Use CAST to return the second column as a varchar. • Use the CONVERT function to return the third column as the same data type as the first column. • Use CONVERT to return the fourth column as a varchar, using style 1. 2. Write a SELECT statement that returns three columns based on the InvoiceDate column of the Invoices table: Use the CAST function to return the first column as data type varchar.

1. Write a SELECT statement that returns four columns based on the Invoice To column of the Invoices table: • Use the CAST function to return the first column as data type decimal with 2 digits to the right of the decimal point. • Use CAST to return the second column as a varchar. • Use the CONVERT function to return the third column as the same data type as the first column. • Use CONVERT to return the fourth column as a varchar, using style 1. 2. Write a SELECT statement that returns three columns based on the InvoiceDate column of the Invoices table: Use the CAST function to return the first column as data type varchar.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 2.11CP

See similar textbooks

Similar questions

Q1. Write a SELECT statement that returns these columns from the Invoices table: The invoice _total column A column that uses the ROUND function to return the invoice_total column with 1 decimal digit A column that uses the ROUND function to return the invoice_total column with no decimal digits Q1. Write a SELECT statement that returns these columns from the Invoices table: • The invoice_total column • A column that uses the ROUND function to return the invoice_total column with 1 decimal digit • A column that uses the ROUND function to return the invoice_total column with no decimal digits invoice_total one digit 3813.33 3813.3 zero_digits 3813
Which of the following statements is true? (refer to the tables in the JustLee Books database.)a. The MIN function can be used only with numeric data.b. The MAX function can be used only with date values.c. The AVG function can be used only with numeric data.d. The SUM function can’t be part of a nested function.
Q1. Write a SELECT statement that returns these columns from the Invoices table: ⚫ The invoice_total column • A column that uses the ROUND function to return the invoice_total column with 1 decimal digit • A column that uses the ROUND function to return the invoice_total column with no decimal digits invoice_total one_digit 3813.33 zero_digits 3813.3 3813
Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION: Use the region table to create a function called ‘Return_region_name’ which accepts an input parameter ‘region_id’, and print the name of the region with that id. Then execute this function with region_id = 1. [LAB-7] (3) B) PROCEDURE: Use the cust_node table to create a procedure called ‘Get_node_id’ that takes the cust_id as an input parameter to show its corresponding node id to the banker. Then execute this procedure with cust_id=5. [LAB-7] (2) C) Trigger: Create a row-level trigger called ‘Compute_Amount_trigger’ on the cust_txn table to automatically update the amount of withdraw transaction made after inserting or updating amount on the cust_txn table. Additionally, this trigger must show this statement ‘TRIGGER MESSAGE: The amount of cust_id and txn_type is modified successfully'. Then test your trigger by updating the cust_txn table. For example, update the amount of the…
1) Write the SQL code that will create the table structure for a table named EMP. This table is a subset of the EMPLOYEE table. The basic EMP table structure is summarized in the table below. (Note that the EMP_NUM is the PK)? ATTRIBUTE(FIELD) NAME DATADECLARATION Constraints EMP_NUM INT Auto generated Identifier, start from 101 EMP_LNAME VARCHAR(15) Not null EMP_FNAME VARCHAR(15) Not Null EMP_INITIAL CHAR(1) EMP_HIREDATE DATE Default value is system date JOB_CODE CHAR(3) Make sure input is in the range500,501,502
Question 5 Suppose that you have the following table: CREATE TABLE coupons ( coupon id INTEGER name VARCHAR2 (30) duration INTERVAL YEAR (3) TO MONTH Now, considers the following INSERT statement: INSERT INTO coupons (coupon id, name, duration) VALUES (4, 'BD1.5 Corn Flakes, INTERVAL 1- 3 YEAR TO MONTH) The above INSERT statement stores the following data: A. 4 BD1.5 Corn Flakes +000-14 4 BD1.5 Corn Flakes +014-00 4 BD1.5 Corn Flakes +014 None of the above
7. Use the UNION operator to generate a result set consisting of three columns from the Products table: Discount status A calculated column that contains a value of DISCOUNTED or FULL PRICE Product_name The product_name column discount_percent The discount_percent column If the product has a discount_percent greater than 0, the Discount_status column should contain a value of DISCOUNTED. Otherwise, it should contain a value of FULL PRICE. Sort the final result set by product_name.
O d. ALTER TABLE tableName MODIFY COLUMN columnName DATATYPE(S) What will be the result after executing this statement: SELECT SUBSTR('International', 6, 6) FROM dual? Oa tional O b. nation O c. Intern O d. national Which of the following is an exnmole of group function?
USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
Write a SELECT statement that returns the following columns from the PRODUCT_INFORMATION table. Sort the results by PRODUCT_ID in ascending order. 1. PRODUCT_ID 2. PRODUCT_NAME 3. LIST_PRICE ○ Use the TO_CHAR function to convert LIST_PRICE to a character string with the currency formatting Give this field an alias of PRICE
Q5) The following table has been created: CREATE TABLE student_table ( Stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ) ; which one of the following INSERT statements will work successfully? a) INSERT INTO student_table (stud_id, last_name, first_name, lunch_name) VALUES (143354, Roberts', 'Cameron',654378); b) INSERT INTO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352678,6543,'Cameron', 'Roberts'); c) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543, 1); d) INSERT INTO student_table VALUES (143354, 'Roberts', 'Cameron', 6543) atabase_MG_2010.pur 10 Tom 31 Jack 11 Sam 12 Sally 14 Sarah 26 Silvia Q6) Based on the Employees table how many rows will result from the following SQL query: ID Name Grade Age Select grade, min(age) from employee where age > 22 group by grade having 1 2 3 1 8 3 a) 6 rows b) 3 rows E c) 2 rows d) 5 rows e) 4 rows 0001010 11101101 010101011111 1010101010101 111010101010…