SQL Interview Report
- 0of 0 votes
Answersthere are 3 tables :
- 11gupt November 11, 2020 in United States
Movie = {movie_id, .....}
Actor = {actor_id, gender, .....}
Movie_Actor = {movie_id, actor_id,....}
Find the pair of movie actor ( male) and actress ( female) who appeared in most movies together.| Report Duplicate | Flag | PURGE
SQL - 0of 0 votes
AnswersTablea Order = {order_id, order_timestamp, total_sale_amount, ....}
- 11gupt November 11, 2020 in United States
Note => Trimmed Mean = remove top and bottom 5 percentile data to remove outliers. Take the average of middle 90% of the data.
you can use function percentile(Col_name, 0.95)
output should look like => {Date, raw_average, trimmed_average}| Report Duplicate | Flag | PURGE
SQL
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.