QI/ By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_amount,vend_name) Vender(vend_code, vend_fname, vend_areacode, vend_phone) 1- find the venders code who sell microwaves products in area that has code 345 and their names include "dan". 2- find the code, name of product that has price less than 3700$ and owned by venders that has code between 9800 and 1110. 3- Find the vender information who had 7 blenders that has price less than the average price of ovens. 4- Find the prodect price that their amount greater than 20 and order them by vender name. 5- add new column to the vender table called p_country

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: In PL SQL, Create a trigger on employees that will not allow employees to update salary for…

A: To create a trigger that restricts updating accountant salary from employee table.

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1…

A: The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who…

Q: Based on the following SQL statement: SELECT acct_id, balance FROM Account WHERE balance < 0 AND…

A:

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: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

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: QL Help I need to create a PL/SQL trigger called aprove_rental that will prevent an INSERT if a…

A: Code  create table client (client_num char(4), client_lname varchar2(15) not null, client_fname…

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: pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your…

A: Here is query of the above alll problem. See below steps.

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: 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: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer: 98877445

Q: Write an sql query to show country code, country name of those employees whose country name…

A: Please refer below for your reference: Queries: 1.SELECT country code, country name FROM employees…

Q: Only q2 Consider the following customer table and write SQL queries. (Queries should be hand written…

A: We need to write a query for question 2.

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: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A:

Q: Write the SQL code to generate the total hours worked and the total charges made by all employees.…

A: See the explanation section for a complete answer.Explanation:To calculate the total hours worked…

Q: Develop a query to provide details about customer sales at the end of 2014. You want the output to…

A: SELECT Sale.ShipToCity, Customer.LastName, Sale.ShipDateFROM Sale JOIN Customer on  Sale.CustID…

Q: Create the following table in your database with the following schema: Table: Products I Column Name…

A: Create table syntax :  CREATE TABLE TABLE_NAME(  column_name  data_type,   column_name  data_type,…

Q: Using DML SQL, write the appropriate SQL query for each of the following: Insert A new customer…

A: In SQL, DML stands for Data manipulation language which contains Select, Insert, Delete and Update…

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: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student  your query get the error because inv_number exist in the two table so you have to…

Q: List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List…

A: The given requirement is to be solved in database SQL where the DOCTOR table is already created with…

Q: Please help with the following: Using oracle sql live or sql developer what sql statements could be…

A: 1.List all the rows in which the prescription dates occur on or after November 14. SELECT * FROM…

Q: 4. Write the SQL code to enter the following data for table STUDENT. StudentID StudentName Phone…

A: The SQL query for inserting the data in the STUDENT table is given below

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

A: Given:

Q: 1. Write the SQL query to show all invoices (LGINVOICE) with a total (INV_TOTAL) of at least $100.…

A: Note: Due to company policies I am compelled to solve only one question and that is the first…

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

A: Answer: 22114454

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.…

Q: I need help with this SQL query:  Write a MySQL statement to create a table named jobs including…

A: Hello student. Warm welcome from my side. Hope you are doing great. I will try my best to answer…

Q: Product(P_code,P_name., P_price, P_quantity, vend_fname) Vender(vend_code, vend_fname, vend…

A: Schemas: Product(P_code, P_name, P_price, P_quantity, vend_fname) Vender(vend_code, vend_fname,…

Q: . Please write SQL codes to query data from member tables based on below criteria  Please write a…

A: A number is odd number if its remainder when divided by 2 is not equal to 0

Q: */By Using the following schema, answer the following SQL queries and commands:…

A: ANSWER:- SEE STEP NO 2