Question: Persons table table [ [ P . Id , LastName,FirstName,Address,City ] , [ 1 , Hansen,Ola,Timoteiva 1 0 , Sandnes ] , [ 2

Persons table
\table[[P.Id,LastName,FirstName,Address,City],[1,Hansen,Ola,Timoteiva 10,Sandnes],[2,Svendsara,Tove,Batgxa 23,Sandoes-],[3,Pettersen,Kari,Storgt 20,Stavanger]]
Orders table
\table[[Ould,OrderNa,Puld],[1,77895,3],[2,44678,3],[3,22456,1],[4,24562,1],[5,34764,15]]
Create the two tables above and insert data in MS-SQL database using SQL.(Do not use GUI)
Write the SQL commands for these:
a. Find the info of the persons whose last name starts with "P".
b. Find the order records for OrdrNo is 24562
c. Count records in each table.
Persons table \ table [ [ P . Id ,

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