select b.author, b.title, printf("%.2f", avg(r.rating)) rating, count(1) review_count
from reviews r inner join books b on r.book_id == b.id
group by r.book_id, b.author
order by 4 desc, 3 desc
limit 5;
Make sure you're on line 1
Press ctrl+f
Find b.author replace all with c.author
Notice the formatting is now all blue:
If you go to the end of the query and do find/replace all, the text color doesn't change.
Hi,
Take this query:
Make sure you're on line 1
Press
ctrl
+f
Find
b.author
replace all withc.author
Notice the formatting is now all blue:
If you go to the end of the query and do find/replace all, the text color doesn't change.