How to write a good prompt to generate SQL query on ChatGPT?

Be clear and specific Make sure your prompt clearly conveys what you want the SQL code to do. Use specific examples and provide all the necessary details, such as table names and column names. This will help chatGPT understand what you're looking for...