Show all the sql query codes and the output with it please Create the following tables in your database with the following schema:Table: customers| Column Name| Type| int| varchar || varchar || customer idI name| country+-------+customer_id is the primary key for this table.This table contains information about the customers in the company.Table: Product| Column Name| ТуреI product_id| descriptionI price| int| varchar || int+-------------+product_id is the primary key for this table.This table contains information on the products in the company.price is the product cost.Table: Orders+-| Column Name| Type+-| order id| customer idI product_id| order dateI quantity| int| int| intdate| int+------+order id is the primary key for this table.This table contains information on customer orders.customer_id is the id of the customer who bought "quantity" products with id"product_id".Order date is the date in format ('YYYY-MM-DD') when the order was shipped.Add the following data to your tables: Input:Customers table:+-----| customer id| countryname+-| 1| 2| 3| winston| Jonathan| Moustafa| USA| Peru| Egypt+-Product table:+-----I product_id| description | price+-| 10| 20| 30| 40| LC Phone| LC T-Shirt| LC Book| LC Keychain | 2| 300| 10| 45+----Orders table:+-----| order id| customer_id | product_id | order_dateI quantity+-| 2020-06-10| 2020-07-01| 2020-07-08| 2020-06-15| 2020-07-01| 2020-06-24| 2020-06-25| 2020-05-08| 1| 1| 2| 2| 10| 2| 2| 3| 1| 2| 3| 1| 1| 1| 2| 2| 3| 3| 3| 10| 20| 30| 10| 40| 20| 30| 30| 5| 7Write an SQL query to report the customer_id and customer_name of customers who have spent atleast $100 in each month of June and July 2020.Return the result table in any order.Hint: You need to use JOINS, GROUP BY, HAVING, CASE (in the HAVING clause) and MONTH()function to check for the month.The results should be:Output:+-| customer id| name+-| 1| winston+-Explanation:winston spent $300 (300 * 1) in June and $100 ( 10 * 1 + 45 * 2) in July 2020.Jonathan spent $600 (300 * 2) in June and $20 ( 2 * 10)Moustafa spent $11o (10 * 2 + 45 * 2) in June and $0 in July 2020.July 2020.

SQL queries : (Note : If in the database there are tables already present so for deleting that table…

Create the following tables in your database with the following schema: Table: customers | Column Name | Туре I customer_id I name | country I int | varchar | | varchar | +-- ---- customer_id is the primary key for this table. This table contains information about the customers in the company. Table: Product | Column Name 1 Туре I product_id I description I price | int I varchar | | int +- product_id is the primary key for this table. This table contains information on the products in the company. price is the product cost. Table: orders | Column Name 1 Туре | order_id | customer_id I product_id I order_date I quantity | int | int | int I date | int order_id is the primary key for this table. This table contains information on customer orders. customer_id is the id of the customer who bought "quantity" products with id "product_id". Order_date is the date in format ('YYYY-MM-DD') when the order was shipped.

Create the following tables in your database with the following schema: Table: customers | Column Name | Туре I customer_id I name | country I int | varchar | | varchar | +-- ---- customer_id is the primary key for this table. This table contains information about the customers in the company. Table: Product | Column Name 1 Туре I product_id I description I price | int I varchar | | int +- product_id is the primary key for this table. This table contains information on the products in the company. price is the product cost. Table: orders | Column Name 1 Туре | order_id | customer_id I product_id I order_date I quantity | int | int | int I date | int order_id is the primary key for this table. This table contains information on customer orders. customer_id is the id of the customer who bought "quantity" products with id "product_id". Order_date is the date in format ('YYYY-MM-DD') when the order was shipped.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 1MC

See similar textbooks

Similar questions

You are working with a database table that contains invoice data. The table includes columns for invoice_id and customer_id. You want to remove duplicate entries for customer ID and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the customer_id column. NOTE: The three dots (...) indicate where to add the clause. 1 2 3 4 5 SELECT ... FROM invoice ORDER BY invoice_id RunReset What customer ID number appears in row 12 of your query result?
3.1 Create a database Cat with the following schema: CREATE TABLE owners ( ownerid integer, name text, age integer, PRIMARY KEY (ownerid) ); CREATE TABLE cats ( catid integer, owner integer, name text, breed text, age integer, PRIMARY KEY (catid), FOREIGN KEY (owner) REFERENCES owners); 3.2. Write a SQL query that returns the number of cats, over the age of 10, of each breed of cat. 3.3. Write a SQL query that returns the ownerid/owner of the one cat owner who owns the most cats.
Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my database and table which is the admin table and the regular table. Can you help me for the right code for the table admin and regular to connect to my database I would appreciate if you would put the right code and SQL query for the connection. Here is my PHP code
You are working with a database table that contains invoice data. The table includes columns for invoice_id and customer_id. You want to remove duplicate entries for customer ID and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the customer_id column. NOTE: The three dots (...) indicate where to add the clause. 1 2 3 4 5 SELECT ... FROM invoice ORDER BY invoice_id ВыполнитьСбросить What customer ID number appears in row 12 of your query result? 0 / 1 балл 16 42 23 8
Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my database and table which is the admin table and the regular table. Can you help me for the right code for the table admin and regular to connect to my database I would appreciate if you would put the right code and SQL query for the connection.
I am new to databases. Using MySQL I am not certain how to make views relevant to the tables in my database. Can I get help explaining how to several views relative to the tables? Here are the tables I set up in MySQL. Employers: CREATE TABLE Employers ( employer_id INT NOT NULL PRIMARY KEY, company_name VARCHAR(50) NOT NULL, company_street VARCHAR(55) NOT NULL, company_city VARCHAR(55) NOT NULL, company_state VRCHAR(2) NOT NULL, company_zip VARCHAR(10) NOT NULL, company_contact VARCHAR(55) ); Customers: CREATE TABLE Customers ( customer_id INT NOT NULL PRIMARY KEY, customer_name VARCHAR(55) NOT NULL, customer_phone VARCHAR(15) NOT NULL, customer_email VARCHAR(40) NOT NULL, customer_education VARCHAR(55) NOT NULL, customer_experience VARCHAR(55) NOT NULL ); Reference: CREATE TABLE Referral ( customer_id INT NOT NULL PRIMARY KEY, referral_first_name VARCHAR(25) NOT NULL, referral_last_name VARCHAR(25) NOT NULL, referral_location VARCHAR(44) NOT NULL, referral_phone VARCHAR(15),…
uppose CompanyLocations has company IDs that don’t appear in CompanyHeadcount. How would you create a single dataset with company ID, location, and headcount, but headcount is set to 0 for companies absent from CompanyHeadcount table? Suppose we have a table which stores Offers data with the following columns: Offer_ID, Candidate_ID, Recruiter_ID, Application_Create_Date, Offer_Extend_Date. Questions: How would you calculate the average time from start to offer extend?
The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the date of the transaction that sells the red shoes- Show the name of the shoe purchased by the customer who has a name with the 2nd character 5 being a vowel- Show the name of the supplier who sells shoes at prices below the average shoe price Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier: INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8'); Merek: INSERT INTO Merek values('AS', 'Adidas','MA');INSERT INTO Merek values('DA', 'Diadora','SS');INSERT INTO Merek values('PA', 'Puma','SO');INSERT INTO Merek…
You are working with a database table that contains invoice data. The table includes columns for invoice_id and billing_state. You want to remove duplicate entries for billing state and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the billing_state column. NOTE: The three dots (...) indicate where to add the clause. SELECT billing_state FROM invoice ORDER BY invoice_id
A mobile app for booking doctor appointments is running very slowly when accessing data from a database and the programmers think that poorly optimised SQL statements are causing it. There are three places where they think the code might be slow. 1. When users book a new appointment. 2. When the date of an appointment is modified. 3. When a user searches for doctors by name or specialty. Could any of these be improved by creating a database index? Why/Why not? What column or columns (if any) would be appropriate to add an index to?
One of the junior database developers has encountered some errors in a query they are working on. The junior developer has requested some assistance from you to solve their errors. Consider the following PL/SQL query: turn serveroutput ondeclaring cust customer.first_name%Type;prod product.product%Type;cursor info isselect cust.first_name || ', ' || cust.surname CUSTOMER, p.productfrom customer cust, billing b, product_billing pb, product pwhere cust.customer_id = b.customer_idwhere b.bill_id = pb.bill_idand p.product_id = pb.product_idand p.price > 10000ordering by p.price;beginsfor rec in infoloopingcust:= rec.CUSTOMER;prod:= rec.product; dbms_output.put_line('CUSTOMER: ' || cust || chr(13) || 'PRODUCT: ' || prod);dbms_output.put_line('------------------------------------');end loop;end; Q.2.1 The code above has errors. Identify the errors and rewrite the code so that it would produce a valid output for the junior database developer.
Question 4 You are working with a database table that contains invoice data. The table includes columns for invoice_id and customer_id. You want to remove duplicate entries for customer ID and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the customer_id column. NOTE: The three dots (...) indicate where to add the clause. 1 2 3 4 5 SELECT ... FROM invoice ORDER BY invoice_id RunReset What customer ID number appears in row 12 of your query result?

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS