1. Table : ASSIGNMENT D ASSIGNMENT N NMAON DATE MM EMP MUN AiNO AlON CHO AONHOURI NON CHA 35 42 t00 22Mar14 22 Mai 1427 22 Mar 148 22Ma 14 8 22 Mar 14 25 22Ma-14 22 117 14 11 117 346 20 0 10 1004 106 100 1007 100 104 113 100 01 01 22 42 2125 40036 190 6 22 Ma14 26 22Mar14 21Mar14 15 23Mar 14 16 09 4180 100 1010 tot 115 117 24 43 34 23 Ma14 1 23 Mar 14 25 23Ma 1422 21 Mar 14 15 23 Mar 1422 23 14 8 2Mar 1425 24 Mar 425 1012 1013 1014 116 104 20 24 19350 a 75 105 106 117 117 0 45 4930 131 29 mot 41.45 61 47 100 00 tota 22 49 1 1019 110.50 125.00 104 001 24 Ma 14 15 101 24 Mar 1422 24Ma1422 24 Mar 14 2 24Ma 14 15 24 Mar. 14 102 1003 115 106 11050 12500 41 45 4376 mes 140 11 502 33 42 117 2. TABLE: EMPLOYEE IMLOVEE New Serwe 1a so 01 Dec s00 Dend 100 104 Ateph Rare Are 10 19 14 Ave K K 01 Feb-s s00 K 106 1000 500 Akreo Wade Rn det Oleko Wan Setee Mare 13 100 15 18 501 11.0ec95.500 04 Ap1 S La (K:110 111 K112 16 12 10 Dele :113 K114 115 116 Deteet entrood Jones K. fewarg Pat 20 Apse ns01 05M 10 19 15 Trw .117 118 Wameoe Fiarma Ged Arg Jumes 10 04 Jnds10 3. TABLE: JOB T C LESCON nO A n LAT PEA 20 N1 20 13 24 Mar14 20 Nov 13 20Nw 13 Phoome Ste Aral Dwatere Desgre Ekica Enge Me npree CENree Clnca o DSS Ara Applom Despe Bo Tachoan C pat 125.00 84 50 07 00 55 00 20 Nw13 20 13 24 Mar.14 20 N 1 20 13 4606 4 10 3405 4. TABLE: PROJECT PROECT ICU HOU . PHOI VALUE N ALANE EM M 1000 00 10 211 n t00M 20 102 2 co 107 5360000 Aber We Mng T :25

Q: List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a…

A: In this question, we are asked to write a SQL query to fetch the unique first and last names who…

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

A:

Q: BOOK_NUM Times Checked Out BOOK_NUM TIMES Checked Out 5236 12 5236 12 No under score line 5235 5235…

A: SELECT  BOOK_NUM, COUNT(check_out_DATE) AS "Times Checked Out " FROM  CHECKOUT GROUP BY BOOK_NUM…

Q: Write the SQL code that will compute the total number of hours worked and total amount billed by all…

A: To compute the total number of hours worked and total amount billed by all workers, we need to have…

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

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: Using the the Employees table below write an SQL query which displays Last Name, First Name and how…

A: As per the table above, we have the ID, LastName, FirstName, Birthdate, Payrate, and HoursWorked…

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: MYSQL Sample Database Diagram productlines *productLine textDescription htmilDescription image…

A: Essential statements used in query: select: The select  statement is used to select data from a…

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: Write SQL code that will return the total number of hours worked for each employee and the total…

A: SQL code: The COUNT function calculates the number of numeric values in a list of inputs. COUNT…

Q: List the LastName, FirstName, and the total number of orders placed by each customer (as OrderCount)…

A: SQL is a structured query language, that's designed to facilitate the extraction the specific…

Q: Using the information in the ASSIGNMENT table, write SQL code that will return the total number of…

A: Introduction: SQL syntaxThe SQL code for connecting the tables "Employee" and "Assignment" to get…

Q: Using the Online SQL Editor, answer the following questions with screenshots. Link:…

A: SQL stands for Structure Query Language. SQL is a widely used language to manage databases in…

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: Find the service ID and property ID for each service request whose estimated hours is greater than…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: Write a query to display the first name, last name, and email address of employees hired from May 1,…

A: Here we have to write 2 queries whose details are as follows:Write a query to display the first…

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: Select clause and from clause: Display the columns specified above in the problem  statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: use sql to Display the employee number, full employee name, job title, and hire date of all…

A: Introduction of SQL in Database: The database is a collection of electronic records that are used to…

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: Please check the step 2 for required sql code

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: How do I list List the ISBN, title, author last name(s), retail price, and the promotional gift for…

A: We have to ginen an Er Diagram in this ER diagram 8 entities And each entities hold some properties.…

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: 7) Write a query to display Unique order dates from the shipper named “Speedy Express”.

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

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: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Q: SQL List location name, owner first name, owner last name, state, unit number, bedrooms, baths, and…

A: Given 3 data base tables location, owner and condo_unit. The SQL only include condos from Solmaris…

Q: Write the SQL code to list the customer ID, first name, last name, street, city, state, zip and the…

A: SQL stands for Structured Query Language. It is a standard programming language designed for…

Q: List the names of the production companies and the titles of their movies. This time, include all…

A: Given that, The names of the tables are Movie and Production Assume that, The attributes of Movie…

Q: Solmaris is offering a monthly discount for owners who pay their condo fees on a quarterly basis.…

A: Actually,the given information is  The discount is 1.75 percent of the monthly fee. For each condo,…

Q: List all the names of the production companies and all the movie titles, all together in one single…

A: Since no sample table and data is provided, I have created two tables, movie and producer. Then I…

Q: List the movie titles and the names of their production companies. Only include production companies…

A: SQL is the language that operates a databases, it includes database creations, deletions, fetching…

Q: Write a query to display the employee number, last name, first name, salary “from” date, salary end…

A: Solution:   Given, Write a query to display the employee number, last name, first name, salary…

Q: Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is…

A: below are the two commands that you can try: 1.   Select PATRON.PAT_ID, BOOK.BOOK_NUM,…

Q: Write sql code for Use derived tables and joins to create a list of players who have scored more…

A: Fielding Table is not given but it is mentioned to consider same as other table. So, we can join all…

Q: You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE…

A: Hello student Greetings   In this scenario, we are required to add a new column to the EMPLOYEE…

Q: CREATE TABLE Employee( firstName char(30) , lastName char(30) , hireDate date ,empNo int ,…

A: The table "Employee" with fields "firstName, "lastName", "date", "empNo", empInitial, and "years" is…

Q: Write an SQL query using the NOT operator that will show all employeeinformation from the Employee…

A: SQL query: SELECT * FROM Employee WHERE NOT Employee_Number = 7344;

Q: Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16…

A: Update statement: The UPDATE statement in the SQL is used to modify existing records present in the…

Q: Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January…

A: Suppose that the table name is EMP_2 that contains columns "PROJ_NUM", "HIRE_DATE", and "JOB_CODE".

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.  

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.