Question: SELECT lname , city, perf FROM emp INNER JOIN loc ON emp.locid = loc.locid WHERE ( state = ' w % ' OR state =

SELECT lname, city, perf
FROM emp
INNER JOIN loc ON emp.locid = loc.locid
WHERE (state ='w%' OR state ='C%' OR state ='F%') AND (perf = 'Good' OR perf = 'Poor')
ORDER BY lname ASC

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

List department name, employee id, and employee name for all employees in department name order. Repeat for department #10 only. List the course ID, course name, section, instructor name, day, time,...

Q:

Please create an SQL query to solve this Return a list of employees who did not receive a bonus. Show position title, state, performance rating and gender. EMP sheet data - SSN FName LName HDate Perf...

Q:

Help Creating Queries for the data below: Example: PAYMENTS OFFICES EMPLOYEES CUSTOMERS Y CUSTOMERNUMBER Y CUSTOMERNUMBER || - EMP LASTNAME FIRSTNAME EXTENSION EMAIL OFFICECODE CHECKNUMBER...

Q:

Answer these queustions using the SQL table below. Aggregation Part of the Exercise . Select the maximum price of any item ordered in the items_ordered table. Hint: Select the maximum price only. ....

Q:

Query 3 : Return a list of employees who work in California, Florida, or Washington who received a performance rating other than Fair . Show LName, City and Perf for these employees. Order by...

Q:

Return a list of employees who work in California, Florida, or Washington who received a performance rating other than Fair . Show LName, City, and Perf for these employees. Order by employee last...

Q:

Query 3: Return a list of empfoyees who work in California, Florida, or Washington who received a performance rating other than Fair. Show LName, City and Perf for these employees. [Create this query...

Q:

can you solve this ? I got some error from this query. Advanced SQL ... Continuation 1. SELECT LName, FName, AGE, ACCTNO, CASE CSTATUS WHEN 'S' THEN 'Single' WHEN 'M' THEN 'Married' END AS STATUS...

Q:

1. Disploy the average hours from Wosks_ON. 2. Dirplay "Total_Number_of_Prolects" for each employee wab their san, name and sumame. 3. Display "Total_tour" for each employee with their ssn, and tiame...

Q:

Can you write 10 Query for this ER diagram? Please make it hard like this and use joins... SELECT LName, Address, City, Region, PostalCode, County FROM Customers WHERE Country = 'Canada' OR Country =...

Q:

Bruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local restaurant local milk supplier charges $0.5 per kg of milk plus a $25 delivery fee (that is...

Q:

Your neighbor, Kitty Kardashian, of Philadelphia, Pennsylvania, bought 55,000 worth of mutual funds with a back-end load of 6 percent if she sells within the first year. It decreases 1 percent a year...

Q:

Hospitals are required to give patients a price quote prior to completing expensive medical procedures. True False

Q:

Assume it is Monday, May 1, the first business day of the month, and you have just been hired as the accountant for Colo Company, which operates with monthly accounting periods. All of the companys...