SQL code on a mac MySQLWorkbench code: Retrieve all the columns for employees whose first name...
SQL code on a mac MySQLWorkbench code:
Retrieve all the columns for employees whose first name is 5 letters.
Retrieve all the columns for employees whose first name is 5 letters and ends with an a
Retrieve all the columns for employees whose first name is 5 letters and starts with a J and ends with an a
Homework Answers
1)Retrieve all the columns for employees whose first name is 5 letters.
answer) assume table name as EMP
SELECT * FROM EMP WHERE LENGTH(FIRSTNAME)=5;
2)Retrieve all the columns for employees whose first name is 5 letters and ends with an a
ANSWER)
SELECT * FROM EMP WHERE LENGTH(FIRSTNAME)=5 AND FIRSTNAME LIKE '%a';
3)Retrieve all the columns for employees whose first name is 5 letters and starts with a J and ends with an a
answer)SELECT * FROM EMP WHERE LENGTH(FIRSTNAME)=5 AND FIRSTNAME LIKE 'J%a';
Add Answer to:
SQL code on a mac MySQLWorkbench code:
Retrieve all the columns for employees whose first name...
SQL query: Write a SQL statement using the employees table and retrieve employees whose monthly salary...
SQL query: Write a SQL statement using the employees table and retrieve employees whose monthly salary (including their commission) is greater or equal to 5,000 but less than or equal to 17,000 (we are assuming the salary on the table is monthly). In other words, if their monthly salary was 1000 and their commission was .2, their total monthly salary would be 1200 and given the criteria above this instance would not be selected. Please display the full name of...
write SQL code list all employee name and employee number (by this order) for all employees...
write SQL code list all employee name and employee number (by this order) for all employees with job code 709
Write an SQL statement that will display the Employee ID, First name (only last 2 letters),...
Write an SQL statement that will display the Employee ID, First name (only last 2 letters), phone number (replace . by /) of all employees whose job Id has a word ‘REP’.
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
SQL MS Acess 1. Display cid, clast, and cfirst for customers whose (last name starts with...
SQL MS Acess
1. Display cid, clast, and cfirst for customers whose (last name
starts with a “D” and has a “v” in the third position) or (first
name ends with an “a”).
2. Display all the columns in Invoice for those invoices that
have less than the average iprice.
3. Display all the columns in Customer for those customers who
purchased a vehicle that has the same date value in icontract and
isold. In other words, customers who signed...
Write an SQL command to Raise the salary of all employees whose salary is below the...
Write an SQL command to Raise the salary of all employees whose salary is below the average salary of all employees.
Write SQL Queries Given the following tables (7pts) Retrieve the names of employees and their project...
Write SQL Queries Given the following
tables
(7pts) Retrieve the names of employees and their
project name. If the employee never worked on a project, show the
names only the name, not the project name.
(7pts) Retrieve the names of employees who have worked
on the same project at a different location.
(7pts) Retrieve the names of employees who have worked
on more than two different projects.
(7pts) Retrieve the names of employees who manage more
than two employees.
CREATE...
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...
ONE SQL STATEMENT for "Retrieve the social security numbers of all direct and indirect supervisees James...
ONE SQL STATEMENT for "Retrieve the social security numbers of all direct and indirect supervisees James E Borg has" NAME SSN BDATE SEX SALARY SUPERSSN DNO ------------------- --------- --------- --- ---------- --------- -------- John B Smith 123456789 09-JAN-55 M 30000 333445555 5 Franklin T Wong 333445555 08-DEC-45 M 40000 888665555 5 Alicia J Zelaya 999887777 19-JUL-85 F 25000 987654321 4 Jennifer S Wallace 987654321 20-JUN-31 F 43000 888665555 4 Ramesh K Narayan 666884444 15-SEP-52 M 38000 333445555 5 Joyce...
write SQL code to list the employee first name, last name, and salary from the employee...
write SQL code to list the employee first name, last name, and salary from the employee table and the department from the jobs table
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
SQL MS Acess
1. Display cid, clast, and cfirst for customers whose (last name
starts with a “D” and has a “v” in the third position) or (first
name ends with an “a”).
2. Display all the columns in Invoice for those invoices that
have less than the average iprice.
3. Display all the columns in Customer for those customers who
purchased a vehicle that has the same date value in icontract and
isold. In other words, customers who signed...
Write SQL Queries Given the following
tables
(7pts) Retrieve the names of employees and their
project name. If the employee never worked on a project, show the
names only the name, not the project name.
(7pts) Retrieve the names of employees who have worked
on the same project at a different location.
(7pts) Retrieve the names of employees who have worked
on more than two different projects.
(7pts) Retrieve the names of employees who manage more
than two employees.
CREATE...
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...
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