Skip to content

Instantly share code, notes, and snippets.

@rana01645

rana01645/gist:08abdd42b5e9eeefad39c9928890b016

Created March 5, 2023 08:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rana01645/08abdd42b5e9eeefad39c9928890b016 to your computer and use it in GitHub Desktop.
Save rana01645/08abdd42b5e9eeefad39c9928890b016 to your computer and use it in GitHub Desktop.
Download ZIP
sql query generation
Raw
gistfile1.txt
Write a sql query to retrieve information about customers, their orders, and the products they ordered. It should return results for customers in New York who placed orders in the year 2022 for products with a quantity of at least 5. The results should be sorted first by order date in descending order, then by product name in ascending order.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment