Browse S

SQL PROBLEMS: FOR PROBLEMS 1-21, DEVELOP THE SQL QUERIES **Refer to employee col

SQL PROBLEMS: FOR PROBLEMS 1-21, DEVELOP THE SQL QUERIES **Refer to employee column broadly as "employee". 1. List lastname, firstname, and department for all employees. 2. Repeat…

SQL PROGRAMMING QUESTION: 1. Using the \'books\' database (which can be found in

SQL PROGRAMMING QUESTION: 1. Using the 'books' database (which can be found in the attached) - Write a one to many join that will select all of the author's first and last names w…

SQL Please help me by filling in the 5 ______ blanks below with the correct SQL

SQL Please help me by filling in the 5 ______ blanks below with the correct SQL commands. Thank you!! Fill in the blanks in the SQL statement below to add to the vendors table a n…

SQL Please help me by filling in the 5 blanks correctly with SQL commands. Thank

SQL Please help me by filling in the 5 blanks correctly with SQL commands. Thank you! Fill in the blanks in the SQL statement below that will list the rows with an invoice_total t…

SQL Please help me by filling in the 7 blanks _________ with the correct SQL sta

SQL Please help me by filling in the 7 blanks _________ with the correct SQL statements. Thank you in advance! Fill in the blanks in the SQL statement below that will create a vie…

SQL Please help me by filling in the 8 ____________ blanks below with the correc

SQL Please help me by filling in the 8 ____________ blanks below with the correct SQL statements. Thank you in advance!! Fill in the blanks in the SQL statement below that will li…

SQL Please help me in put in the correct SQL commands in the 6 blanks ______ bel

SQL Please help me in put in the correct SQL commands in the 6 blanks ______ below. Thank you in advance! Fill in the blanks in the SQL statement below that will list the invoice …

SQL Plus workshop question As you do the exercises, it is a good idea to copy/pa

SQL Plus workshop question As you do the exercises, it is a good idea to copy/paste your query as well as your query result into a word processor. 3-2 Create two tables, T1(ename,…

SQL Practice - Submit SQL statements Using the tables (cs3350.branches, cs3350.t

SQL Practice - Submit SQL statements Using the tables (cs3350.branches, cs3350.transactions, cs3350.employees, cs3350.customers) CS3350.EMPLOYEES ( EMPLOYEE_ID NUMBER, BRANCH NUMB…

SQL Practice - Submit SQL statements Using the tables (cs3350.branches, cs3350.t

SQL Practice - Submit SQL statements Using the tables (cs3350.branches, cs3350.transactions, cs3350.employees, cs3350.customers) CS3350.EMPLOYEES ( EMPLOYEE_ID NUMBER, BRANCH NUMB…

SQL Practice exercises Exercise chapter 2 2-1. a. Create a table called Cust wit

SQL Practice exercises Exercise chapter 2 2-1. a. Create a table called Cust with a customer number field as a fixed-length character string of 3, an address field with a variable…

SQL Problem http://imgur.com/v3ViaAx You can use the Adventure_Works 2014 data b

SQL Problem http://imgur.com/v3ViaAx You can use the Adventure_Works 2014 data base, get the avg price and sum of yr-to-date sales, grouped by prodID and specialofferID in Sales/S…

SQL Problem http://imgur.com/v3ViaAx You can use the Adventure_Works 2014 data b

SQL Problem http://imgur.com/v3ViaAx You can use the Adventure_Works 2014 data base, get the avg price and sum of yr-to-date sales, grouped by prodID and specialofferID in Sales/S…

SQL Problems (a) List the names of all directors for whom no movies have been en

SQL Problems (a) List the names of all directors for whom no movies have been entered into the Movies table. (b) For each director, list the number of movies by that director and …

SQL Programming I am having trouble writing the correct code, any help would be

SQL Programming I am having trouble writing the correct code, any help would be great. Using subqueries 1.    This query uses only the countryLanguage table. Create a query that l…

SQL Programming I am having trouble writing the correct code, any help would be

SQL Programming I am having trouble writing the correct code, any help would be great. Using subqueries 1.    This query uses only the countryLanguage table. Create a query that l…

SQL Programming I am lost and any help would be great SQL queries that join mult

SQL Programming I am lost and any help would be great SQL queries that join multiple tables. 1. Display complete country name and language spoken in that country. (Use the country…

SQL Programming Query1: Add a Staff table to the database with the following col

SQL Programming Query1: Add a Staff table to the database with the following columns: staff_id, staff_first, staff_last, staff_phone, staff_position, hotel_id. hotel_id should be …

SQL Programming Query1: Add a Staff table to the database with the following col

SQL Programming Query1: Add a Staff table to the database with the following columns: staff_id, staff_first, staff_last, staff_phone, staff_position, hotel_id. hotel_id should be …

SQL Programming Query1: Add a Staff table to the database with the following col

SQL Programming Query1: Add a Staff table to the database with the following columns: staff_id, staff_first, staff_last, staff_phone, staff_position, hotel_id. hotel_id should be …

SQL Programming Report three values found in the PAYINFO table and store them in

SQL Programming Report three values found in the PAYINFO table and store them in variables. Output should be: Values are 15, 18.5, 40 DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREA…

SQL Programming This is the question I am working on. Display the number of year

SQL Programming This is the question I am working on. Display the number of years that each country has been independent in ascending order of years of independence. Display the d…

SQL Programming This is the question I am working on. Display the number of year

SQL Programming This is the question I am working on. Display the number of years that each country has been independent in ascending order of years of independence. Display the d…

SQL QUERIES 1. Display all sale orders that were paid with split payments of a c

SQL QUERIES 1. Display all sale orders that were paid with split payments of a card and a check 2. display highest servc price and the amount of sales containing it 3. display cli…

SQL QUERIES TO BE IMPLEMENTED FOR TESTING DATABASE ARE AS FOLLOWS : Identify the

SQL QUERIES TO BE IMPLEMENTED FOR TESTING DATABASE ARE AS FOLLOWS: Identify the names of all customers whose age is 20. Show the name of all the books with third edition from Inve…

SQL QUESTION Implement and test an aggregate that calculates the product of all

SQL QUESTION Implement and test an aggregate that calculates the product of all the numbers in a table. Include the correct DROP statements above your aggregate, functions, and ty…

SQL QUESTION drop table roles; drop table movies; drop table directors; drop tab

SQL QUESTION drop table roles; drop table movies; drop table directors; drop table actors; create table actors (actorid integer, actorname varchar(30), actordob date, actordod dat…

SQL Querie Give Tables: STUDENT ( int:student number, varchar(20):name, varchar(

SQL Querie Give Tables: STUDENT ( int:student number, varchar(20):name, varchar(20):address, primary key (student number)) INSTRUCTOR ( int:instructor ID, varchar(20):name, varcha…

SQL Queries Does the company offer any products that it has not sold? If yes, wh

SQL Queries Does the company offer any products that it has not sold? If yes, what products have not been sold? The above can include answering the following questions: How many d…

SQL Queries Exercise: Assume the following Tables: Table: ACTOR Columns: id, fir

SQL Queries Exercise: Assume the following Tables: Table: ACTOR Columns: id, first_name, last_name, gender Table: MOVIES Columns: id, name, year, rank Table: ROLES Columns: actor_…

SQL Queries Exercise: Assume the following Tables: Table: ACTORS Columns: id, fi

SQL Queries Exercise: Assume the following Tables: Table: ACTORS Columns: id, first_name, last_name, gender Table: MOVIES Columns: id, name, year, rank Table: ROLES Columns: actor…

SQL Queries For the below schema for a company door: doorlog(eventid,doorid,tim,

SQL Queries For the below schema for a company door: doorlog(eventid,doorid,tim,username,event) Where doorid represents the door for this event. e.g. Front door may be doorid=1, a…

SQL Queries from these tables: a. Write a SELECT statement using a single table

SQL Queries from these tables: a. Write a SELECT statement using a single table that includes an arithmetic calculation and a single row function(i.e TRUNC, ROUND, etc).   Format …

SQL Queries in MySQL **This is using the Sakila Sample database which can downlo

SQL Queries in MySQL **This is using the Sakila Sample database which can downloaded here: https://dev.mysql.com/doc/sakila/en/ ** Write a query that produces the last name, first…

SQL Queries in MySQL This is using the Sakila Sample database which can download

SQL Queries in MySQL This is using the Sakila Sample database which can download here:    https://dev.mysql.com/doc/sakila/en Write a query that produce the last name and email ad…

SQL Queries in MySQL This is using the Sakila Sample database which can download

SQL Queries in MySQL This is using the Sakila Sample database which can download here:    https://dev.mysql.com/doc/sakila/en Add a row to the Film Database before working on this…

SQL Queries in MySQL This is using the Sakila Sample database which can download

SQL Queries in MySQL This is using the Sakila Sample database which can download here:    https://dev.mysql.com/doc/sakila/en Instructions: Add a row to the Film Database before w…

SQL Queries in MySQL: Counting This is using the Sakila Sample database which ca

SQL Queries in MySQL: Counting This is using the Sakila Sample database which can download here:    https://dev.mysql.com/doc/sakila/en **Note that you will be performing a query …

SQL Queries in MySQL: Multiple Tables This is using the Sakila Sample database w

SQL Queries in MySQL: Multiple Tables This is using the Sakila Sample database which can download here:    https://dev.mysql.com/doc/sakila/en **Note that you will be performing a…

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and DEPT tables explained in the lecture notes and available in Oracle APEX. Use Oracle APEX to try out…

SQL Queries. Attached is the ER Diagram for the Database. Also, you can use an i

SQL Queries. Attached is the ER Diagram for the Database. Also, you can use an imaginary recipe database, schema, recipe, column or row name. Task 1: Pull a full list of ingredien…

SQL Queries. Write a query that will list the customer(s) who had ordered the ma

SQL Queries. Write a query that will list the customer(s) who had ordered the maximum number of items (2 copies of the same book will be counted as 2 items). CUSTOMER table: BOOKO…

SQL Queries. Write a query that will list the publisher(s) with the maximum numb

SQL Queries. Write a query that will list the publisher(s) with the maximum number of books published. BOOK table: PUBLISHER table: Thank you! BOOK PUBDATE BOOK PUBID BOOK COST BO…

SQL Queries. a) Write a query that will list the publisher(s) with the maximum n

SQL Queries. a) Write a query that will list the publisher(s) with the maximum number of books published. b) Write a query that will list the customer(s) who had ordered the maxim…

SQL Queries. d) Write a query to list all the books with multiple authors. Also

SQL Queries. d) Write a query to list all the books with multiple authors. Also display the number of authors who wrote the book. BOOK table: BOOKAUTHOR table: AUTHOR table: BOOK …

SQL Queries: At least 10 queries using joins (involving at least two tables in e

SQL Queries: At least 10 queries using joins (involving at least two tables in each query and three tables in three of the queries), aggregate functions, “group by” functions etc.…

SQL Query * Query 5. For products that meet both (a) and (b) conditions of Query

SQL Query * Query 5. For products that meet both (a) and (b) conditions of Query 4, if we rank them in Z -> A order of ProductID, i.e., from largest to smallest and the one wit…

SQL Query Assignment The schema of these relations is: Courses (course, credits,

SQL Query Assignment The schema of these relations is: Courses (course, credits, days, tine, room, title, prof, dept) Profs (pname, given, office, ext, email) Students (name, give…

SQL Query Display the trade id stock i and total price for the secondary market

SQL Query Display the trade id stock i and total price for the secondary market trade with the highest total price. Convert prices to U.S dollars select tr.trade_id, tr.stock_id, …

SQL Query HELP pls. 1. Find the First and last names and addresses of employees

SQL Query HELP pls. 1. Find the First and last names and addresses of employees who work on at least one project that is not located in Stafford but works in the department that h…