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 with ids between 20 and 100.
Select all queries below that, for the faulty records, set the year to 2015.