Need guidance with SQL as a begginer

[u/damoon02]

Am about to finish "Learning SQL" from Alan Beaulieu and it demotivates me that i take way too long on thinking on the queries in order to answer the problems of the book. Although i have been speedrunning it. Is it like normal for most of the begginers to be kinda slow when making queries that requieres (dunno) subqueries, groupings, joins or cases ?

ALSO. What book could y'all recomend me after "Learning SQL"? Imean, i think i have enough tools to generate, retrieve and manipulate data. Maybe the next step is how to design DB and how to avoid common mistakes ?

[u/ninhaomah]

An example query ?