(https://dev.mysql.com/doc/refman/8.0/en/functions.html).Choose 1 string function and 1 numeric function and write a query that uses the two functions you chose in the same query. Create 3 separate queries. customersordersorder_itemscustomer_id INTorder_id INTorder_item_id INTfirst_name VARCHAR(45)customer_id INTO order_id INTlast_name VARCHAR(45)address1 VARCHAR(128)order_date DATEproduct_id INTorder_status INTprice DECIMAL (8,2)city VARCHAR(128)shipped DATEIndexesO delivered DATEPRIMARYorder_id_idxproduct_id_idxstate VARCHAR(2)zip VARCHAR( 10)Indexescountry VARCHAR(2)PRIMARYphone VARCHAR(12)customer_id_idxemail VARCHAR(128)order_status_idxtwitter VARCHAR(45)IndexesPRIMARYIkp_status_id statuslookup_order_statusproductsPendingIkp_status_id INTproduct_id INTAwaiting PaymentAwaiting FulfillmentAwaiting ShipmentAwaiting Pickup3status VARCHAR(45)artist VARCHAR(45)4Indexestitle VARCHAR(128)5Partially ShippedPRIMARYreleased INTCompletedShippedprice DECIMAL (8,2)Cancelledmedia VARCHAR(45)10Declined11Refundedstock INT12DisputedIndexes13Partially Refunded14DeliveredPRIMARY15Returned

The given problem is related to MYSQL querie where the logical model of the tables is given and the…

Answered: hoose 1 string function and 1 numeric…

hoose 1 string function and 1 numeric function and write a query that uses the two functions you chose in the same query. Create 3 separate querie

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 14MC: A unique identifier for a data row that consists of more than one field is commonly called...

See similar textbooks

Related questions

Q: Create a function name BALANCE that returns the status of outstanding amount for each customer. Use…

A: Required : Function name : BALANCE It returns the status of outstanding amount for each customer. IF…

Q: Write SQL statements that will 1. create a table named Flavors with columns itemcode(int),…

A: The solution for the above-given question is given below:

Q: How would I write this function in exel? In the Time Goal field of the Log table, you will display…

A: INDEX returns a value from a range or an array depending on its location in the array, or index. The…

Q: Find the output of the following query. SELECT LENGTH(REPLACE ('FINALEXAM FINALEXAM, F;"TAN')) FROM…

A: Answer : the Given SQL Output is 23 : Because string will replace 'F' to 'TAN' so, the final string…

Q: ents Correct SELECT statement and aggregate function used. Correct FROM statement. Correct WHERE…

A: here have to determine about SQL query for given problem.

Q: SELECT MAX(datediff(minute,start_time,end_time)) as "Longest_ride",…

A: Your SQL code contains error related to function datediff.

Q: A) Write a query which shows the employee IDs that are unique to the employee table. Order the…

A: Solution A) - In the first part, we need to write a query to employee Ids and the employee should…

Q: Please produce a set of normalized relations for the following statements.

A: As here is no mention of the type of Normalization. I am writing 1NF Table: Employee emp_num…

Q: MYASQL 7. Create Avgoffreight() stored procedure to retrieve the average of freight from Orders…

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B Becomes the last column in the table

Q: Run a query that reports back the average of each exam in the same query.

A: The following query will return the average of each exam- exam1, exam2 and exam3 in the same query:…

Q: Create a query for selecting Employee_Id , First_Name, Phone_Number where Department_ID is not in…

A: Create table and insert data into it CREATE TABLE EmpDetails( Employee_Id INT PRIMARY KEY ,…

Q: Code three tests: 1) for a student who has courses 2) for student who does not have courses 3) a…

Q: IN SQL ** 1- Write a query clause to display the internal structure of the departments table, then…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Which of the following function find the “Number of months between two dates”? a. Add_months b.…

A: Answer : Months_between function is responsible for finding the Number of months between two dates.…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Q: 19. The following code refers to the sample data in the table people. What is the result of each…

A: Note: - As per the guidelines we can only answer one specific question at a time. Please resubmit…

Q: develop a PL/SQL block that selects the maximum department ID in the departments table and stores it…

A: PL/SQL(Procedural Language / Structured Query Language) is the embedded procedural language and the…

Q: The following query throws an error. Choose the correct reason for the error as given in the options…

A: Here B and C both part are correct R square always increase with increase in number of variable…

Q: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

A: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

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: Translate the following SQL query to a pandas statement in Python so that it can be executed on the…

A: count(*)-count number of rows satisfying the condition sqldta-table name conditions;- case>1000…

Q: Your task for this assignment is to use SQL to implement the basic relational operations of…

A: 1. Answer: CREATE TABLE orders (orderID int, orderName varchar(255), status varchar(255));INSERT…

Q: Install the Customer/Orders database by select SQL Work Shop => Utilities => Sample Dataset. Write…

A: Query: SELECT PRODUCT_ID, PRODUCT_NAME FROM Orders INNER JOIN Customer ON…

Q: Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code…

A: Command:- CREATE TABLE EMPLOYEE(Employee_Id integer PRIMARY KEY, Last_Name text, Salary integer);…

Q: Write a procedure which takes customer id as argument and return name of customer and his/her total…

A: Question : -Write a procedure which takes customer id as argument and return name of customer and…

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: rite MySQL functions to accomplish the following tasks: A:Delete the order whose number is stored…

A: write MySQL functions to accomplish the following tasks: A:Delete the order whose number is stored…

Q: What are the different types of the aggregate functions?

A: Here in this question we have asked what are the different types of aggregate function we used in…

Q: uperior, RANK() or DE

A: function is superior, RANK() or DENSE RANK()

Q: Explain in detail the syntax and functionalities of the following Mongoose code:…

A: Below is the explanation:

Q: Write the SQL query to display the cid of all employees. Write the SQL code to list all…

A: According to company rules we are only supposed to answer 3 subparts kindly upload the other…

Q: Write a SQL command please Write a query that displays the last name in uppercase letters and…

A: This query can be solved using different SQL functions. Here is the answer with explanation.

Q: This clause in SQL join is based on all columns which have the same names, but the data types do not…

A: b. USING clause

Q: A (n) ______ is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence…

A: RDBMS is relational database management systems which is based on relational model.

Q: Your task for this assignment is to use SQL to implement the basic relational operations of…

A: 1. Answer: CREATE TABLE orders (orderID int, orderName varchar(255), status varchar(255));INSERT…

Q: 3. Create a procedure, ADD_EMPLOYEE, to insert a new employee into the EMPLOYEES table. The…

A: Note: As per our guidelines we are supposed to answer only one question. Kindly repost the other…

Q: PLZ help with the following: in SQL A right outer join on tables CUSTOMER and AGENT yields all of…

A: given statement is False A right outer join on tables CUSTOMER and AGENT yields all of the rows in…

Q: 6. Study the following block, and answer the questions below: (a) What are declared in the package…

A: PL/SQL package :- Package is a logical groping of related procedure/function(subprograms) in a…

Q: In advanced SQL, which of the following is a SQL query that performs execution of outer query for…

A: SQL (Structured Query Language) is a quality programming language that helps in managing the…

Q: Use single-row subquery in a HAVING clause. List customer numbers of customers who paid total amount…

A: A unmarried row subquery returns 0 or one row to the outer SQL assertion. You can area a subquery in…

Q: Create a MySQL table named 'prime_test' that contains two columns. The first column is an integer…

A: Syntax for creating table: CREATE TABLE table_name ( column1 datatype [ NULL | NOT NULL ],…

Q: uld like to create a function to sum up total order amount within the date range, but i don't know…

A: We need to update select [State], count (*) as [TotalOrderAmount] FROM [SQLBook].[dbo].[Orders]…

Q: How to learn creating user-defined functions in sql - IsNewHire: Take a hire date as an argument,…

A: A relational database contains tables also known as relations. A table has rows and columns which…

Q: a. Write a query to get all unique first names that start with the letter W from the student table.…

A: To solve queries like starts with letter ‘W’ , sql has like operator with wild card operators i.e %…

Q: Assume there're n film categories. Let L = Min(L1, L2, .. Ln) where Li = the length of the longest…

A: РоstgreSQL is used аs the рrimаry dаtа stоre оr dаtа wаrehоuse fоr mаny web, mоbile,…

Q: SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions…

A: Code: select p_descript from product where v_code in (select v_areacode from vendor where v_areacode…

Question

100%

(https://dev.mysql.com/doc/refman/8.0/en/functions.html).

Choose 1 string function and 1 numeric function and write a query that uses the two functions you chose in the same query. Create 3 separate queries.

customers
orders
order_items
customer_id INT
order_id INT
order_item_id INT
first_name VARCHAR(45)
customer_id INT
O order_id INT
last_name VARCHAR(45)
address1 VARCHAR(128)
order_date DATE
product_id INT
order_status INT
price DECIMAL (8,2)
city VARCHAR(128)
shipped DATE
Indexes
O delivered DATE
PRIMARY
order_id_idx
product_id_idx
state VARCHAR(2)
zip VARCHAR( 10)
Indexes
country VARCHAR(2)
PRIMARY
phone VARCHAR(12)
customer_id_idx
email VARCHAR(128)
order_status_idx
twitter VARCHAR(45)
Indexes
PRIMARY
Ikp_status_id status
lookup_order_status
products
Pending
Ikp_status_id INT
product_id INT
Awaiting Payment
Awaiting Fulfillment
Awaiting Shipment
Awaiting Pickup
3
status VARCHAR(45)
artist VARCHAR(45)
4
Indexes
title VARCHAR(128)
5
Partially Shipped
PRIMARY
released INT
Completed
Shipped
price DECIMAL (8,2)
Cancelled
media VARCHAR(45)
10
Declined
11
Refunded
stock INT
12
Disputed
Indexes
13
Partially Refunded
14
Delivered
PRIMARY
15
Returned

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

Introduction

SQL FUNCTIONS

Queries

Conclusion

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above
Delete the index named ITEM_INDEX3.
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column and the Num_ Shares column only from the rows where Selling_Price is greater than Purchase_ Price and Num_Shares is greater than 100. The results should be sorted by the Num_Shares column in ascending order.
INPUT TABLE You're given a orders table and the columns in the orders table are shown below: Orders Order_Id INT Type VARCHAR(10) Red_Shipping_ Days INT Scheduled_Shipping_Days INT Customer_Id INT Order _city VARCHAR(20) Order_Date DATE Order_Region VARCHAR(15) Order_State VARCHAR(20) Order _Status VARCHAR(20) Shipping_Mode VARCHAR(20) QUERY Calculate count of all the orders. Where Order_ State is Maharashtra Note - Use the alias of oc for count of orders Group the results by Type Order them by oc in ascending order. OUTPUT COLUMNS oc, Type
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns only the Trading_Symbol column from every row in the table.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column and the Num_Shares column from every row in the table.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns all the columns from the rows where Trading_Symbol starts with "SU".
Assume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted by the Num_Shares column in ascending order.