Homework Answers
14)
The answer is option a.
Explanation:
The union is used to combine the result set of two or more
queries.
The respective columns should have the same data types.
when the names are different, the names from the first query will
determine the name in the result set.
15)
The answer is option b.
The union can be used any number of times between two or more
queries.
When we want to combine the result sets of more than two queries ,
the union can be used multiple times.
16)
The answer is option b(FROM).
The join is used to get the data from multiple tables.
The FROM clause in the select statement is used to specify the
tables on which the join operation is being performed.
Add Answer to:
14. When the corresponding columns in a UNION have different names, what is the name of...
Hi good day i need homework help fast please d32 1./What is the maximum length that...
Hi
good day i need homework help fast please
d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate...
5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate Return only the rows where the ShipDate column contains a null value. 6. Write a SELECT statement that returns all columns from the Addresses table State is equal to CA 7. Write a SELECT statement that returns all columns from the Products table Product name has a "ru" in its name 8. Write a SELECT statement that returns these columns from the Customers table...
Answer the following SQL study guide questions... Question 1 (1 point) Unless you assign a column...
Answer the following SQL study guide
questions...
Question 1 (1 point) Unless you assign a column name in the base table. the column name in the result set is the same as the 1) unique syntax 2) column alias 3) qualification 4) all of the above Question 2 (1 point) Which clause specifies the number of rows that should be skipped before rows are returned from the result set? 1) FETCH 2) OFFSET 3) FIRST 4) NEXT Question 3 (1...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName,...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY...
Database in using Employees table given able Write a SELECT statement to get employees first name...
Database
in using Employees table given able Write a SELECT statement to get employees first name and starts with "A" 25). Write a SQL code for the following inquiries us reccords in the employees table where Write a SELECT statement to count the number of r lastname starts with "C" question "B" 2) If you have to write a SOL code to ioin between EMPLOY e will you join on? Provide the column name. ) I which col
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named ge...
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named getSalesSortedByNames. Your function will have 2 parameters. The first parameter is a database cursor and the second parameter is a float. Your function should start by retrieving those rows in the staff table whose totalsales field is equal to the second parameter. (The next paragraph shows the Python...
QUERY EXAMPLE2 SELECTfrom Employee em (Refer to query example 2 to answer questions 12- 13) 12....
QUERY EXAMPLE2 SELECTfrom Employee em (Refer to query example 2 to answer questions 12- 13) 12. You plan to join the Location table and fear there may be some employees with no location. You want to make sure that the query returns a list of all employee What join clause would you add to the query above? records. A. LEFT JOIN Location lo ON em.LocationlD lo LocationID B. RIGHT JOIN Location lo ON em.LocationID lo.LocationlD C. INNER JOIN Location lo...
Hi this is for SQL Use the AP database Vendor name from the vendor table Vendor...
Hi this is for SQL Use the AP database Vendor name from the vendor table Vendor Contact First Name and Vendor Contact Last Name from the vendor table but I need them concatenated together with a space between the names Invoice Date from the invoice table Only the day of from the Invoice Date Invoice Number from the invoice table The third and fourth characters from the Invoice Number Line Item Amount from the invoice line items table Calculate the...
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to...
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to 20. StfID StfFName StfLName 1011 Eric Smith 65000 1012 Ann Jordan 70000 1013 Linda Greenberg 63000 1014 Jose Hernandez 56000 1015 Lee Jones 77000 18. Which statement regarding the SQL query below is correct? (Reminder: The table name is Staff) select StfFName, Salary, (0.05* Salary) as HolidayBonus from Staff where StID=1012; A) The report will have a column named StfID, and 1012 will be...
PRINT Lab Week 2, Question 1 What channel is SYFY? --------------------- Write a SELECT statement that...
PRINT Lab Week 2, Question 1 What channel is SYFY? --------------------- Write a SELECT statement that finds the channels named SYFYP and SYFYHDP in the CHANNEL table of the TV database. Use a WHERE clause with an OR statement to return only these two channels. Display only the ChannelNumber and DisplayName columns. Hint: Correct results will look like this (note that DisplayName is 200 characters wide, so I''ve edited a bit): ChannelNumber DisplayName ------------- ----------- 59 SYFYP 1411 SYFYHDP '...
Hi
good day i need homework help fast please
d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate Return only the rows where the ShipDate column contains a null value. 6. Write a SELECT statement that returns all columns from the Addresses table State is equal to CA 7. Write a SELECT statement that returns all columns from the Products table Product name has a "ru" in its name 8. Write a SELECT statement that returns these columns from the Customers table...
Answer the following SQL study guide
questions...
Question 1 (1 point) Unless you assign a column name in the base table. the column name in the result set is the same as the 1) unique syntax 2) column alias 3) qualification 4) all of the above Question 2 (1 point) Which clause specifies the number of rows that should be skipped before rows are returned from the result set? 1) FETCH 2) OFFSET 3) FIRST 4) NEXT Question 3 (1...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY...
Database
in using Employees table given able Write a SELECT statement to get employees first name and starts with "A" 25). Write a SQL code for the following inquiries us reccords in the employees table where Write a SELECT statement to count the number of r lastname starts with "C" question "B" 2) If you have to write a SOL code to ioin between EMPLOY e will you join on? Provide the column name. ) I which col
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named getSalesSortedByNames. Your function will have 2 parameters. The first parameter is a database cursor and the second parameter is a float. Your function should start by retrieving those rows in the staff table whose totalsales field is equal to the second parameter. (The next paragraph shows the Python...
QUERY EXAMPLE2 SELECTfrom Employee em (Refer to query example 2 to answer questions 12- 13) 12. You plan to join the Location table and fear there may be some employees with no location. You want to make sure that the query returns a list of all employee What join clause would you add to the query above? records. A. LEFT JOIN Location lo ON em.LocationlD lo LocationID B. RIGHT JOIN Location lo ON em.LocationID lo.LocationlD C. INNER JOIN Location lo...
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to 20. StfID StfFName StfLName 1011 Eric Smith 65000 1012 Ann Jordan 70000 1013 Linda Greenberg 63000 1014 Jose Hernandez 56000 1015 Lee Jones 77000 18. Which statement regarding the SQL query below is correct? (Reminder: The table name is Staff) select StfFName, Salary, (0.05* Salary) as HolidayBonus from Staff where StID=1012; A) The report will have a column named StfID, and 1012 will be...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago