Posts

Find all employees who have or had a job title that includes manager. Output the first name along with the corresponding title.

You have been asked to find the fifth highest salary without using TOP or LIMIT. Note: Duplicate salaries should not be removed.

You are given a table of tennis players and their matches that they could either win (W) or lose (L). Find the longest streak of wins. A streak is a set of consecutive won matches of one player. The streak ends once a player loses their next match. Output the ID of the player or players and the length of the streak.

CALL MATE Revolve 16W Wireless Bluetooth 5.3 Soundbar with 10Hrs Playtime, FM Radio | USB, AUX, TF Card | Digital Clock/Alarm, BT Speaker for TV, Mobile, PC, Laptops, Tablets (Grey)

Vaseline Healthy Bright Complete 10 Body Lotion, Anti- Ageing Lotion With Vitamin B3, Aha, Pro-Retinol, 400 ml

Amazon prime membership

Cadbury Dairy Milk Chocolate Shots Carton (58 Units x 3.6 Gm), 208.8 g