medium
Generate SQL Join Query
Create a SQL query to join two tables and filter data.
📝 프롬프트 내용
Write a SQL query for a PostgreSQL database that selects the customer name and order total from the customers and orders tables. Join the tables on customer_id. Filter the results to only include orders placed after January 1st, 2023, with a total value greater than 500.