QI/ By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_amount, vend_code) 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 “mur". 2- find the code, name and vender code of product that has price between 1500$ and 2500$ and the product that has price between 4800$ and 5600$. 3- Find the name, and code of venders who had 5 microwaves that has price less than 3500$.

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: Write SQL queries to answer the following questions:a. Which studen ts have an ID number that is…

A: SQL queries are given below

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

A:

Q: Without re-creating the table write one sql statement to answer this question. Change the definition…

A: Actually, database is a used to store the data and we can change ,manipulate and access the data.

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: 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: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

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 a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetailID from…

A: Introduction: A JOIN clause is used to merge data from more than "2" tables based on a standard…

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: 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: write sample sql quiries for these Write a query to display employee number, first name, job id…

A: Please refer below for your reference: Queries are: 1. SELECT employee number, first name, job id…

Q: Using Pubs: USE MICROSOFT SQL SERVER Create a query listing all the books that Barnum’s purchased.…

A: I attached your answer below.

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: by using the table in the query attached: Show the name, contact number and email address of the…

A: Demo data has been used to solve the query The SQL query is given below with output screenshot

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: SQL queries

A: According to the question, we need to write the SQL queries of the following questions: Write a…

Q: Select FirstName,LastName,department,project_name,hours from employeetab,Project where…

A: This SQL code aims to select certain columns from two tables, employeetab and Project, join them…

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: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the &lt;, &gt;, &lt;=, &gt;= comparison operators.

Q: write the query that updates the manager of the female employee who has 'c' as the last letter of…

A: Given : write the query that updates the manager of the female employee who has 'c' as the last…

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: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

Q: Your manager requires you to create an SQL query that will display the combined customer name, the…

A: SQL query to select customer name ,townhouse number ,material and purchase amount ,in which purchase…

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: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…

Q: a. Find all movies with a cost less than or equal to the average moVies cost b. Write a query to…

A: Select Query:          It will retrieve data from the table.         select * from table name;…

Q: appropriately. Table: Author Column Name Data Type Size/Length Constraint Type AID Number Primary…

A: SQL Queries:1. create table Author ( AID Number, AName Varchar2(20) Not Null, Lang Varchar2 (50),…

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

A: Here is the all query of the problem. See below steps for code.

Q: Write an SQL query using the IN operator to show all customers residingin the following zip codes:…

A: As the database is not given we have assumed the database CUSTOMERS. SQL query to create table…

Q: Write all the sql code (including create, insert and select)

A: in the following section we will be writing the queries based on information provided in the above…

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: Create the following tables in your database with the following schema: Table: Countries | Column…

A: We need to write code of create table and insert table only.

Q: Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000.…

A: Let the table name be emp which has the following columns   employee_id, first_name, last_name,…

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetaillD from…

A: Introduction: Structured Query Language (SQL) is an acronym for Structured Query Language. SQL is a…