Answer:
The following query is used to display TripName. Reservationld, FirstName. LastName and TotalCost of trip by adding the trip price plus other fees and multiplying the result by the number of persons which have number of persons >4.
Query:
SELECT ReservationlD, Trip.TripName. Customer.LastName. Customer.FirstName. (TripPrice+OtherFees) 'NumPersons as TotalCost FROM Reservation, Trip, Customer WHERE NumPersons>4 AND Reservation.TriplD=Trip.TriplD AND
Customer. CustomerNum=Reservation.CustomerNum:
Explanation:
- Select clause is used to retrieve data from specified database table or relation and returns the data in the form of table.
- ReservationID. Trip.TripName. Customer.LastName. Customer.FirstName are the column name of table.
- (TripPrice+OtherFees) 'NumPersons will calculate the total cost of the Trip and stored it into TotalCost column.
- As clause is used to give new name TotalCost to resultant column.
- FROM clause specifies one or more table from where records to be retrieved. o Reservation. Trip and Customer are the table name.
- WHERE clause is used in SQL query to retrieve only those records that satisfy the specified condition
Answer:
k = 1.91 × 10^-5 N m rad^-1
Workings and Solution to this question can be viewed in the screenshot below:
The right components for gsm architecture that consists of the hardware or physical equipment such as digital signal processors, radio transceiver, display, battery, case and sim card is the Mobile station.
<h3>What are the 4 main components?</h3>
In GSM, a cell station includes 4 fundamental additives: Mobile termination (MT) - gives not unusualplace features consisting of: radio transmission and handover, speech encoding and decoding, blunders detection and correction, signaling and get right of entry to to the SIM. The IMEI code is connected to the MT.
Under the GSM framework, a cell tele cell smartphone is called a Mobile Station and is partitioned into wonderful additives: the Subscriber Identity Module (SIM) and the Mobile Equipment (ME).
Read more about the mobile station:
brainly.com/question/917245
#SPJ4
