1 Views Create Views Following Scenarios Show View Definition Queries Please Also Execute Q37106724

by

1. Views: create views for the following scenarios. Show yourview definition queries. Please also execute a SELECT * query oneach view, and show the results.

1.1 Create view BigShips: numbers and names of ships weight morethan 75000 tons

1.2 Create view CruiseInfo: cruise number, director, name of theship used for the cruise, weight of the ship, builder of theship.

SQL query: SELECT FROM VISIT CRUISENUMİPORTNA ME| COUNTRY | DEPDATE ARRDAT United States 2003-08-05 00:00:00 2003-09-11 00:00
The Cruise Scenario SQL query: SELECT FROM SHIP SHIPNUM SHIPNAME 005 008 BUILDER LAUNCHDATE WEIGHT Sea Joy The Spirit of Nash

SQL

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.