Describe a minimum of three (3) heuristics to optimize Queries. Provide the SQL

Describe a minimum of three (3) heuristics to optimize Queries. Provide the SQL code (and screen shots) based on the following criteria: You must deliver five (5) queries in total for this assignment. One of your five queries must select from three (3) different tables. Four of your queries must select from two (2) tables. Include comments on how you are using the optimization rules you described and discussed earlier. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.