Question: Create a query to select first and last name from the student table where first name is Tracy, John, James or Jennifer. Hint use IN

Create a query to select first and last name from the student table where first name is Tracy, John, James or Jennifer. Hint use IN on where clause Paste your query below

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!

Oracle SQL Developer HW: 1.Write a SELECT statement that returns three columns: vendor_id vendor_id from the Vendors table vendor_name vendor_name from the Vendors table contact_name A concatenation...

Midwest Executive Professionals IMPROVE A DATABASE BY CREATING AND MODIFYING TABLES, QUERIES, FORMS, AND REPORTS - GETTING STARTED . Open the file IL_AC19_CS1-4a_FirstLastName Waacob, available for...

Illustrated Access 2013 Unit B: SAM Project 1a Tours Database USING QUERIES PROJECT DESCRIPTION You work for an adventure tour company that operates recreational hiking, biking, and walking tours in...

need help on how to complete this project in a step by step/ click by click way. sani New Perspectives Access 2016 Modules 1-4: SAM Capstone Project la Sandra Coates Skating Club CREATING TABLES,...

MSIS / IT 2 3 0 Phase 5 Requirements Selects Using Multiple Tables In this phase you will demonstrate your knowledge of selecting data from multiple tables. You will need to use techniques such as...

I need 12, 14(the one closest to 15), and 15. For 12 if a person has a 'bill' address at all they are not supposed to be outputted even if they have another address. PERSON: Iname, fname, rname,...

4. (12 points) LGS Investment's database contains all of the information on the properties the firm has listed and sold. You are a manger with this firm and want to use the database to determine the...

New Perspectives Access 2013 Tutorial 5: SAM Project 1a Physical Therapy Specialists, P.C. creating specialized queries and enhancing a databaseName PROJECT DESCRIPTIONJennifer Christie wants to...

can someone help me with this please let me know if you need more info Required information [The following information applies to the questions displayed below.) This Applying Excel worksheet...

Determine the maximum amount of work obtainable in a flow process from 1 kg of steam at 3.000 kPa and 450oC for surrounding conditions of 300 K and 101-33 kPa?

Show that the brake in Problem is self locking i.e., P 0, provided b/c ? s . M.

What is the expected loss ratio obtained from the simulation results of the net present value? Group of answer choices 9 3 . 5 0 % 7 2 . 4 5 % 6 7 . 3 2 % 8 6 . 3 2 %

Fred Slezak presented the following comparative balance sheet: FRED SLEZAK CORPORATION FRED SLEZAK CORPORATION Statement of Cash Flows For the Year Ending December 31, 20X5 Cash flows from operating...