SQL Aggregates: COUNT(*) aggregate function

wow thank you!!

how to fix the error "is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."?

would you please help me to solve this on sql????

The columns dir and ctry contain values indicated as '-', and we need to
change these to Not Given while also capitalizing the first letter of each word
in the columns. Using the movies table, write a SELECT statement that meets
the following conditions:
a Show the column show_id;
b Create a CASE statementG
) WHEN the column dir is equal to , THEN output it as Not Given
) ELSE output using the INITCAP() function to the column di&
) Give the resulting column an alias AS director;
c Create another CASE statementG
) WHEN the column ctry is equal to , THEN output it as Not Given
) ELSE output using the INITCAP() function to the column ctr\
) Give the resulting column an alias AS country;
d Order the given result by the column show_id (in ascending order).

Thank You very much, Sir 🤍

Man you deserve million subscribers...

I needed to find out how to put a title on the aggregate count option and this video showed me how to do that. Thank you!

Thank you so much sir. Greatest explanation.

Thanks for making this video had some trouble on this function but i get it now thanks to you!

thanks a lot the video was so useful

Great explanation

Great!

THANK U, I REALLY APPRECIATE IT!!! <3

Good stuff