Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I don't understand what I'm doing wrong with my SQL Query. It's running on Microsoft Access 2016 and the table is under the name EMPLOYEE.
I don't understand what I'm doing wrong with my SQL Query. It's running on Microsoft Access 2016 and the table is under the name EMPLOYEE. Every time I enter this code in it will show the Column headers for FirstName, LastName, and Cellphone but it seems to reject every attempt I make to use an AND or LIKE statement.
FirstName | LastName | ExperienceLevel | CareerPath | Department |
---|---|---|---|---|
Bill | Johnson | Master | Plumber | Maintenance |
Jerry | Smith | Master | Accounting | Finance |
Phil | Klein | Rookie | Night Guard | Security |
John | Billson | Rookie | Accounting | Finance |
SELECT FirstName, LastName, CareerPath FROM EMPLOYEE WHERE FirstName LIKE ('J%') AND ExperienceLevel = 'Master'
;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started