You have a database with a customers table. Here is a partial listing of the records:First_NameLast_NameMichelleSenseAlexisRodriguezFloraSatoYou also have a table of employees. Here is a partial listing of the records:First_NameLast_NameSamuelClementineAlexisRodriguezJabariReddyYou want to create a query that will not return “Alexis Rodriguez” as part of the results. You begin typing your query:SELECT First_Name, Last_Name FROM customers________SELECT First_Name, Last_Name FROM employeesWhat should you type in the blank space between the two queries? (Please type your answer all in upper case. Example: SELECT)

You are given a table Employee which has the following columns :id, FirstName, LastName.You have to use a query to display all those employees whose first names start with the letter ‘R’ and end with the letter ‘I’. Some queries are given below -(a) SELECT * FROM Employee WHERE FirstName LIKE '%RI%';(b) SELECT * FROM Employee WHERE FirstName LIKE 'R%' AND FirstName LIKE '%I';(c) SELECT * FROM Employee WHERE FirstName LIKE 'R' AND 'I';(d) SELECT * FROM Employee WHERE FirstName LIKE 'R%I';Choose the most appropriate option from below :Options: Pick one correct answer from belowOnly (c)Only (b)(b) and (d)(b), (c) and (d)(a) and (c)None of the above

You have a sales table that has a salesAmount and a customerNumber field. You need to find the You are creating a query that will join the results of two tables. You begin typing the query:SELECT customers.firstName, customers.lastName, orders.orderDateFROM customers ______ JOIN ordersON customers.customerNumber = orders.customerNumberYou want to see all the rows from the customers table, even if they don’t have a corresponding record in the orders table.What should you type in the blank space? (Please type your answer all in upper case. Example: SELECT or UNION ALL)

Find Customer RefereeGiven a table customer holding customers information and the referee.idnamereferee_id1WillNULL2JaneNULL3Alex24BillNULL5Zack16Mark2Write a query to return the list of customers NOT referred by the person with id'2'. For the sample data above, the result is:nameWillJaneBillZackOptionsselect namefrom customerwhere referee_id is null or referee_id <> 2;select namecustomerwhere referee_id is null or referee_id <> 2;select referee_idfrom customerwhere referee_id is null or referee_id <> 2;select namefrom customerwhere name is null or referee_id <> 2;

Your query did not return the expected result; see below for further information.Your query resultYour query has returned the following result:namePeter SellersSigourney WeaverExpected resultThe expected result was the following:nameSigourney WeaverSusan SarandonDifference from the expected resultYour query did not return the following rows that are part of the expected result:nameSusan SarandonUnderstanding what went wrongYour query has been executed on the following database.Inspect the database to understand why your query did not return the expected result.Knowsid personA_id personB_id17 11 1219 11 1315 11 1418 12 1316 14 12Likesid personA_id personB_id19 11 1416 12 1118 13 1117 13 1215 14 12Personsid name address age eyeColor gender11 Woody allen Madrid 63 brown male12 Peter Sellers Amsterdam 19 brown male13 Susan Sarandon Paris 33 green female14 Sigourney Weaver Paris 24 blue female

select customerid,concat_ws(" ",firstname,lastname) as name,timestampdiff(curdate(),Date_of_Birth,Year) as agefrom customersorder by age,customeridcorrect this