Product(P_code,P_name., P_price, P_quantity, vend_fname) Vender(vend_code, vend_fname, vend areacode, vend age, vend nationality) 1- find the venders names who sell phones and microwaves and order them by the the product names 2- find the code, name and vender name of product that has price greater than 1800OS and less than 2500S and their quantity less than 5. 3- Find the vender information who had 5 microwaves that has price less than the average price of ovens. 4- Find the names and area code of iraqi venders and younger than 33. 5- Delete all the air fans product that has price under 2500.

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Display the maximum price of all the products in PRODUCTS table for each Supplier ID having a…

A: Here we need to join Table Supplier and PID. Since they have common attribute,they can be joined…

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: We need to insert some columns from property table to largeproperty table whose square footage is…

Q: 1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to…

A: It is defined as a Structured Query Language, is a programming language designed to manage data…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…

A: A relational database contains tables. Tables are also called relations and they contain rows and…

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: SOQL Assignment Salesforce: You have to write a SOQL query in which we have to find out all the…

A: Use the Salesforce Object Query Language (SOQL) to search your organization’s Salesforce data for…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

Q: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: Some rows of a User table are shown below:   User ucode name phone scode 7 Alex 847 - 3902…

A: Names and phone numbers are among the details about different users that are included in the User…

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: The command DESC DEPARTMENTS shows the following information Name Null? Type DEPARTMENT ID NOT NULL…

A: Let's see the answer

Q: ccording to tables below, Write 3 SELECT statements to exemplify FULL OUTER JOIN statement

A: Full outer join -  Full outer join combines the result of left outer join and right outer join. It…

Q: CourselD CourseNumber Description Credit Filter | Fiter Filter Filter 10001 MISM4221 System . 10002…

A: Create table COURSE using create table command. Define columns CourseID, CourseNumber, Description…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Orders Table: OrderID,CustomerID, Order Date, TotalAmount Customers Table: CustomerID, CustomerName.…

A: In this question we have to create a query to retrieve the customer name and order date for each…

Q: With the following table:   PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)   Write…

A: Given table is:PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)Write the mySQL statement…

Q: EMPLOYEE TABLE EMPLOYEE_ID FIRST_NAME SURNAME CONTACT NUMBER emp101 0877277521 emp102 emp103 emp104…

A: The queries for creating and inserting data to all tables are given below along with final OUTPUT…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: 5. For each order, list the order number, quoted price and the item description, when the category…

A: 5. To get the required results, we need to use ORDERS, OPRDERLINE, ITEM tables Query: SELECT…

Q: Display CustomerName and Status as 'Q2 for every customer who was born during the 2nd quarter of…

A: The given problem is related to database SQL query. The problem has provided the msCustomer table…

Q: Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd…

A: Overview : The COUNT() function returns the number of rows that matches a specified criterion. The…

Q: The code: "SELECT SupplierlID FROM Products Order By SupplierName DESC;" extracts data from Products…

A: Sol1: Current procedure terminology (CPT) is a code such as reflex testing and is an integrated part…

Q: Assume the PRODUCT table contains multiple rows. The following code would include: SELECT…

A: Dear Student, The answer to your question is given below -

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

Q: Create a LARGE_PROPERTY table

A: Statements are written for MySQL database. Steps: 1. Create table LARGE_PROPERTY 2. Insert Values…

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN ID DELIVERY_ DATE 1001 300…

A: b) SELECT * FROM PURCHASE_ORDER INNER JOIN PURCHASE_DETAILS ON PURCHASE_ORDER.ORDER_NO =…

Q: Need to create two store procedures with help.

A: Answer:1.DROP PROCEDURE IF EXISTS p_property;GOCREATE PROCEDURE p_property_allAS BEGIN  SELECT *…

Q: Find the names and surnames of the customers who received the "Kalem" in 2018 but did not receive it…

A: Note: we have provided answer according to table and attributes mention in picture part. we need to…

Q: Find the name and the age of the youngest graduate student (use subquery).

A: Subquery is a query written inside another query and here we use this concept to find the minimum…

Q: Based on the ERD below, display all assigned numbers that had an assigned charge per hour greater…

A: The assignment number of the assignment is displayed in which the charge is greater than 84.5 and…

Q: Below are some rows of the PROVIDERS table for a factory:   PCODE NAME PHONE 10192 Hans, Inc.…

A: In this casе,  wе arе working with a "PROVIDERS" tablе for a factory,  and thе goal is to rеtriеvе…

Q: Insert the following records into the tables LIBRARY and MEMBER Table: LIBRARY Вook_Type ok_ID |…

A: INSERT statement inserts records to a table by mentioning the column names and respective values of…

Q: How many days, years did quitting employees work in their past jobs. Name Null? Туре NUMBER (6)…

A: Here is the query for the the time span of the employees work

Q: Based on the following table, please find the customers who locate in the same state.…

A: DBMS stands for Database Management System. It is a software system that enables users to create,…