Breaking down customer transactions in SQL
Given the following table containing customer transaction data:
Table name: orders
Write SQL queries to answer the following:
- Return all rows in the data table with transaction values over $101.
- Return all rows in the data table with transaction values over $101 that were purchased through the Online channel.
- Return all rows in the data table with transaction values that were either over $101 OR were purchased In_store.
- Return the minimum transaction amount for both channels as well as the corresponding order id.
Subscribe to premium account to see the solution.Get premium now