Solve the following query:
![from reader,team]()
Top Questions on SQL
- An OTT company is maintaining a large disk-based relational database of different movies with the following schema :
Movie (ID, Customer Rating)
Genre (ID, Name)
Movie Genre (MovieID, GenreID)
Consider the following SQL query on the relation database above :
SELECT *
FROM Movie, Genre, Movie_Genre
WHERE
Movie. CustomerRating > 3.4 AND
Genre.Name = "Comedy" AND
Movie_Genre.MovieID = Movie. ID AND
Movie_Genre.Genre ID = Genre. ID;
This SQL query can be sped up using which of the following indexing options ? - Want to practice more? Try solving extra ecology questions todayView All Questions
Questions Asked in GATE AR exam
A four-arm uncontrolled un-signaled urban intersection of both-way traffic is illustrated in the figure. Vehicles approaching the intersection from the directions A, B, C, and D can move to either left, right, or continue in straight direction. No U-turn is allowed. In the given situation, the maximum number of vehicular crossing conflict points for this intersection is _________ (answer in integer)
- GATE AR - 2025
- Traffic survey methods, Traffic flow Analysis
An individual chooses a transport mode for a particular trip based on three attributes i.e., cost of journey (X), In-vehicle travel time to reach destination (Y), and Out-of-vehicle time taken to access mode at respective stops (Z). The values for these attributes for three modes Rail, Bus and Para-transit are given in the table. If the general utility (U) equation is \( U = - 0.5 \times X - 0.3 \times Y - 0.4 \times Z \), using the Logit model, the estimated probability of choosing Bus is _________ (rounded off to two decimal places).
- GATE AR - 2025
- Transportation