Create the following table in your database with the following schema: Table: Sales | Column Name | Type | sale id I product_name | varchar | | sale_date | int I date +----- --+ sale_id is the primary key for this table. Each row of this table contains the product name and the date it was sold. Add the following data to your tables: Input: Sales table: +-------- I sale_id | product_name | sale_date I | LCPHONE | LCPhone | LcPhOnE | LCKEYCHAIN | LCKeyChain | Matryoshka | 1 | 2 | 2000-01-16 | | 2000-01-17 | | 2000-02-18 | | 2000-02-19 | | 2000-02-28 | | 2000-03-31 | | 4 Since table Sales was filled manually in the year 2000, product_name may contain leading and/or trailing white spaces, also they are case-insensitive. Write an SQL query to report • product_name in lowercase without leading or trailing white spaces. • sale_date in the format (YYYY-MM'). • total the number of times the product was sold in this month. Return the result table ordered by product_name in ascending order. In case of a tie, order it by sale_date in ascending order. Hint: you may need to use the following functions: • LOWER() • TRIM() • DATE_FORMATO The results should be: Output: I product_name | sale_date I total | | lckeychain | lcphone | lcphone | matryoshka | 2000-02 | 2000-01 | 2000-02 | 2000-03 | 2 | 2 1. | 1

Q: use the following data to add a default value unknown to the structure of part .descripti

A: The given ERD has two tables as: Detail_Line PART The relationship is: One details_line has one PART…

Q: In SQL, which command is used to SELECT only one copy of each set of duplicable rows

A: In SQL command which  is used to SELECT only one copy of each set of duplicable rows are:-

Q: Write the following insert statements. 3. Insert a guest into the table, Guest, using the following…

A: Answer: 3)Performing insert statement: INSERT INTO Guest(guestNo, lastName, firstName, phoneNo,…

Q: Create a query based on the EMP table that satisfies the criteria below Use the TO_CHAR function to…

A: Solution:   When you install Oracle 11g Enterprise Edition there are couple databases you can chose…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: SQL code: to add an additional column  ex:   ALTER TABLE chicken ADD dish varchar(30) Question: How…

A: Alter table is used to add or modify table structure.  In sql it is possible to add default values…

Q: In SQL, the WHERE clause to the SELECT statement states the criteria that must be met: Multiple…

A: EXPLANATION: SQL is a database language that allows you to store, manipulate, and retrieve data.…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: Please start from declare the variable  Using SQL*Plus and SQL Developer tool, complete the…

A: Structured query language is a querying database perform query against given data

Q: If you omitted the WHERE clause of an UPDATE or DELETE statements, the query returns an error…

A: Delete statement without WHERE clause will delete all the records of the table and without proper…

Q: When creating a table in SQL, you must specify whether the column is NULL or NOT NULL.   a. True…

A: SQL

Q: In SQL Code: Write code snippet to show how value from Bind Variable can be passed to a PL/SQL…

A:

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: Please use Pl/sql ro answer the following question, and red had been provide First create below…

A: The answer is...

Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…

A: SELECT * FROM MagazineWHERE Cost>amt1 AND Cost<amt2;

Q: List every table that contains a column named OWNER_NUM. The output table should display one column…

A: The first ever freely programmable computer came into play in 1936, however after that International…

Q: Which clause of a SQL Select statement is required if we want to display aggregate data by category…

A: Answer: 5) GROUP BY

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: Create a SQL statement to Display the CID, CName, Gender, and RType from bo

A: Answer: Always specify the tables to solve Sql i have solved it without table names if it does not…

Q: Based on the following table ,write the SQL command to create the table.

A: CREATE TABLE Dentist(DentistID varchar(10) PRIMARY KEY,DentistName varchar(255),DentistEmail…

Q: ROOMS RID RType Rate Bedroom Room_Status CID 101 Studio 10 1 Available   102 Studio…

A: SELECT  - It is used to query or retrieve data from a table in the database AS  - This command is…

Q: Explain the purpose of the CHECK clause within a CREATE TABLE SQL command. Explain the purpose of…

A: Given: Explain the purpose of the CHECK clause within a CREATE TABLE SQL command. Explain the…

Q: Create a SQL statement to Display the RID, RType and Bedroom of all ROOMS whose number of bedrooms…

A: 1. The query is SELECT RID, RType, Bedroom FROM Rooms WHERE Bedroom < (SELECT Bedroom FROM Rooms…

Q: The SQL command CREATE TABLE EMPLOYEE_BACKUP AS SELECT * FROM EMPLOYEE creates a new table named…

A: CREATE TABLE AS Statement: The SQL CREATE TABLE AS statement used to create a table from an…

Q: Create a view named 'EmployeeReport' that contains the employee name, employee surname and the total…

A: SOLUTION : To create the view of surname, name, and total days work let us take the employee table…

Q: Write a select statement to create the inner join of tables sec1310_table1 and sec1310_table2. The…

A: The above question is solved in step 2 :-

Q: 10. Produce a list of each customer number and the third and fourth digits of his or her zip code.…

A: The query for a list of each customer number and the third and fourth digits of his or her zipcode…

Q: Perform the following function • Alter the table by adding a column salary • Alter the table by…

A: i) Alter table table_name add Salary int; ii) Alter table table_name Alter Column Name varchar(50);…

Q: 5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit…

A: Required:

Q: Topic: Sql in Ms Access How to display lastname and firstname of all employees in alphabetical order…

A: The select query will be used to select first name nad last name . Order by clause will be use…

Q: CREATE OR REPLACE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition; in…

A: Given: CREATE OR REPLACE VIEW view_name ASSELECT column1, column2, ...FROM table_nameWHERE…

Q: a)Create 3 tables(product_categories,products,product_sale) with primary key,foreign key in each…

A: Initially 3 tables are created product, product_category, product_sale. Each table is related to…

Q: Table Valued Function: ufn_FetchAllAppointments This function fetches all the appointment details…

A: As Given, Function is: ufn_FetchAllAppointments We have to fetch all the appointment details from…

Q: 2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate…

A: The question has been solved in step2:

Q: Column Name Data Type Constraint (Column Level) DoctorID Number(4) Should not be empty and not…

A: The table is created using the following query. Create table query for the table Doctors: Create…

Q: 6. 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: Q1. Create a stored procedure that will list all customers (name and number) represented by rep 15.…

A: create table cust_records(cust_num int primary key,cust_name varchar(30));insert into cust_records…