my sql practice file

Attached is my practice sql file.  please let me know if you have any comments or advice on my sql code.  Thanks!