SQL is the dominant technology for accessing application data. It is increasingly becoming a performance bottleneck when it comes to scalability. Given its dominance, SQL is a crucial skill for all engineers.
Conditional statements are a feature of most programming and query languages. They allow the programmer to control what computations are carried out based on a Boolean condition.
Public questions (free plan) are common interview questions. They are great for practicing, or if you want to filter candidates using the classic problems.
A table containing the enrollment year has incorrect data in records where the id is between 20 and 100 inclusive.
Select all queries below that, for the faulty records, set the year to 2015.