![maskythegamer](/avatars/6334.jpg)
maskythegamer
07.04.2020 •
Computers and Technology
Create a view named NHTrips. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and season for every trip located in New Hampshire (NH). Display the data in the view.
Solved
Show answers
More tips
- A Auto and Moto Battle for the Relocation of The Cherkizovsky Market: Who Won?...
- F Food and Cooking Homemade kvass: recipe and brewing process...
- O Other What is a Disk Emulsifier and How Does it Work?...
- H Health and Medicine How to Calm Your Nerves? Expert Tips That Actually Work...
- A Animals and plants 5 Tips for Taking Care of Yews to Keep Them Green and Beautiful...
- S Sport How to wrap boxing hand wraps? Everything you need to know!...
- F Food and Cooking 10 Reasons Why You Should Avoid Giving Re-Gifts: An Informative Guide...
- F Family and Home Tender Care for Your Parquet: Is it Possible to Clean Parquet?...
- S Style and Beauty How Are Eyelash Extensions Applied? All Your Questions Answered...
- F Food and Cooking 10 Tips for Proper Sushi Consumption...
Answers on questions: Computers and Technology
- C Computers and Technology When was the name musically changed to tik tok?...
- S Social Studies Hat do forensic psychology, forensic linguistics, and forensic archaeology all have in common?...
- E Engineering Steam at 3 mpa, 300°c leaves the boiler and enters the hp turbine in a reheat cycle and is expanded to 300 kpa. the steam is then reheated to 300°c and expanded in the second stage...
- S Social Studies Forms that tend to be irregular and similar to naturally occurring objects are known as...
- C Computers and Technology Specialized vocabularyis known as: o equivocal terms o jargon o trigger words o biased language...
- M Mathematics Find all local extrema for f(x, y) = 4y3 + 18x2 − 36xy. (if an answer does not exist, enter dne.)...
- E Engineering Statistics is very much concerned with the distributions of data sets, hypothetical distributions of populations and sampling distributions. a)true b)false...
- H History How did women first enter the public sphere in early-nineteenth-century america? how did women broaden american notions of freedom before the civil war?...
- E Engineering Starting from the weak form of the governing equation, using the galerkin method with two elements, with boundary con- ditions u(0) = 0 and uz(l) = 0 , and without specified external...
- S Social Studies Features of advantages disadvantages is visually engaging plays a major role in political conversation influences the public agenda is controlled by media executives allows little...
Ответ:
CREATE VIEW NHTrips AS
SELECT TripID,
TripName,
StartLocation,
Distance,
MaxGrpSize,
Type,
Season
FROM trip
WHERE State = 'NH';
Explanation:
A view is a user’s view or application program’s view of the database created for execution during a database operation such as those for displaying results, modification of record, updating and deletion of records. It is created by defining a SELECT query and then using a CREATE VIEW command.
syntax for creating view;
The view is created as follows,
Give a view name using the CREATE VIEW command and give optional field names followed by the query using the SELECT statement
I.e
CREATE VIEW viewname
[(column name1, column name2….)] AS Select statement
When the above query is executed, a view named NHTrips will created in the database.
Ответ: