Question: write an sql statement that shows the list oc employees that their firstname either has four letters or less or starts by D - Write

write an sql statement that shows the list oc employees that their firstname either has four letters or less or starts by D write an sql statement that shows the list oc employees that their

- Write a SQL statement the shows the list of employees that their first name either has four letters or less or starts by O. SELECT Firstname "Name", length(firstname) length" FROM Employees where firstName like "ox br firstname (4) SELECT * FROM Employees WHERE firstName - length(firstName) yeeNumber Fiter Row lastame firstName Murphy Diane Patterson Mary Ferrel Jeff Patterson Wiliam Bondur Gerard Bow Anthony Jennings Lese Thompson Leste Frrell Bule Patterson Steve Tseng Foon Yue Varauf George Bond Lou Hernandez Gerard Castillo Pamela Bott Larry Editi Export/Imports extension email X5800 dmurphy @dassicmodelcars.com 4611 mpattersodassicmodelcars.com x9273 frreldassicmodelcars.com 4871 wpatterson Odass modelcars.com x5400 gbondurassicmodelcars.com abowclassicmodelcars.com 3291 jennings classicmodelcars.com 4055 Ithompsondassicmodelcars.com X2173 firreliodassicmodelcars.com x4334 spatterson@dassicmodekors.com x2248 ftseng@dassicmodelcars.com 4102 gvanaudassicmodelcars.com bondurassicmodelcars.com x2023 Chernande dessicmodelcars.com x2759 pcastilodassicmodelcars.com X2311 bottedassicmodelcars.com Wrap Cel Content I officeCode reportsToyob Title 1 nul President 1 1002 VP Sales 1 1002 VP Marketing 6 1056 Sales Manager (APAC) 4 1056 Sale Manager (EMEA) 1 1056 Sales Manager (NA) 1 Sales Rep 1 1143 Sales Rep 2 1143 Sales Rep 2 1143 Sales Rep 3 1143 Sales Rep 3 1143 Sales Rep 4 1102 Sales Rep 4 1102 Sales Rep 4 1102 Sales Rep 7 1102 Sales Rep tion Output Time Action Merge 5 13:01:35 SELECT * FROM Employees WHERE Nome - larghitune) -4 or fintrame 20% 23 row) returned 6 13:05:23 SELECT Frame "Name" FROM Employees WHERE frame ke "02" or frame length firstNomo) - 4 23 row() returned 7 13:06 27 SELECT Prstname "Name" longthstrane) orgh" FROM Employees WHERE Nome like "D%" Tow) returned 8 13:07 47 SELECT Findiname "Name" length frame) length" FROM Employees WHERE franke "D" or frame-4 23rowb) returned 23 row) returned 9 13.11:59 SELECT * FROM Employees WHERE first Name lengths Name) 4 or frstrane * 0%

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 Databases Questions!