QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name, P_price, P_quantity,vend_name) Vender(vend code, vend fname, vend areacode, vend_ salary, vend_nationality) find the names of products that owned by vender "smith" and not owend by vender "dan." 1- find the name, price and quantity of product that has code 34657 and owned by spanish venders. 2- 3- Find the name of iraqi venders who has salary less than the average salary of venders.

Q: Write a SQL query that displays the number of customers who born on the 16th day of a month .  Write…

A: 1. select count(customerID) from Customers where to_char(custDOB,'DD') = 16; 2. select customerID…

Q: PLZ help with the following use oracle or oracle sql live problem is in image the database CREATE…

A: The complete answer is given below.

Q: will you represent the following multiple relation in SQ

A: The relationship between Dormitory and Student is one to many with the participation of Dormitory be…

Q: Get a list of the number of products reviewed for every retailer

A: TABLES The tables based on the given forms are shown below. Product ( PID, ModelName, Category,…

Q: SELECT TO CHAR (DOB, 'DD/YY/MM') FROM patients WHERE Medical_no=1001;

A: Given: select TO_CHAR(DOB,'DD/YY/MM) from patients WHERE Medical_no = 1001.   Explanation this is…

Q: the each customer total annual premium and order by the highest total annual premium to the least.…

A: I have written the query below:

Q: Create the following table in your database with the following schema: Table: Departments Column…

A: Required statement  table creation and inserting data in university database given below.

Q: Schema:  Employees (EmpID int, Name varchar(50), Age int, Salary float, DepartmentID int)…

A: HI THERE,I AM ADDING ANSWER BELOWPLEASE GO THROUGH ITTHANK YOU

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: How do I create a query that includes first name, last name, email and state for all customers and…

A: Query:-   SELECT first_name, last_name, email, state, CASE WHEN customer_type = 'Customer' THEN 'C'…

Q: Customer(cid,name,surname,city,address,phone); Account(aid,cid,amount,created,comment);…

A: - We need to write a sql query to get the names, surnames and phone number according to the transfer…

Q: Use sub queries to answer the following Q1) write a query to display the employees first name and…

A: Note:- since table name is not we had given queries according to question given Syntax:   select…

Q: STUDENTCOURSE(stdID, course_code, grade) Which SQL statement will find the summation of maximum…

A: Working query: it will select max first and then sum them   SELECT sum(max(grade)) FROM…

Q: Write the SQL queries for the following questions and show results. List all the section numbers of…

A: In the structured query language, the query consists of the three clauses that are used to retrieve…

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: Given that there are two tables Employee and Orders. The attributes of each table are:…

Q: help with sql class  2 questions  1. Report the names of all authors and the title_name of the…

A: Let's see the answer:

Q: Write in SQL a command that creates the table Customers according to the above description (2…

A: SQL answers to the above first 3 questions are in step2 as per our guidelines we are supposed to…

Q: 1. How many reviews for every product?

A: Let us suppose that the table is created as given below: create database DB; use DB; create table…

Q: QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name., P_price,…

A: Given:   We have to write a following schema using SQL queries.

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: QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name., P_price,…

A: The ORDER BY keyword is used to sort the result-set in ascending or descending order. The BETWEEN…

Q: Write the following SQL queries based on the following relational schema: Student (stdID: char(5),…

A: Ans:- So let’s start solving the problem here I give the complete SQL query of the problem and…

Q: question 6 please use the  picture below to answer the following question Write a SQL statement to…

A: Explanation: “UNIQUE” constraint is used to ensure that the column having different values. The…

Q: With SQL code, find the name of each employee with a manager along with their manager's name (use…

A: For finding this query  we will use the join clause.

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Given:

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: The INSTR() function returns the position of the first occurrence of a string in another string.

Q: question 11 please use the picture below to answer the following question Write a SQL statement to…

A: Query: The below query is used to modify the InvoiceDate to today’s data for the customer ID 10.…