Question: Persons table table [ [ P . Id , LastName,FirstName,Address,City ] , [ 1 , Hansen,Ola,Timoteiva 1 0 , Sandnes ] , [ 2
Persons table
tablePIdLastName,FirstName,Address,CityHansen,Ola,Timoteiva SandnesSvendsara,Tove,Batgxa SandoesPettersen,Kari,Storgt Stavanger
Orders table
tableOuldOrderNa,Puld
Create the two tables above and insert data in MSSQL database using SQLDo 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
c Count records in each table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
