AI Natural Language Query

Ask questions about your data in plain English
500 characters remaining
Music Store Dataset

You run an independent music store selling guitars, basses, drum sets, keyboards, amplifiers, effects pedals, recording gear, and accessories. You carry major brands like Fender, Gibson, Pearl, Roland, and more, in both new and used condition. You also offer music lessons for guitar, bass, drums, piano, and vocals. You have 18 months of sales data, a product catalog, customer records, and lesson bookings to explore.

Analyzing your question...

Try these questions
Available Data
📅 Aug 2024 through Aug 2026
Tables: ms_products, ms_customers, ms_sales, ms_lessons

Products — name, category (Guitars/Bass Guitars/Drums & Percussion/Keyboards & Pianos/Amplifiers/Effects Pedals/Recording Gear/Accessories), brand, price, cost, condition (new/used)
Customers — name, email, phone, first_purchase
Sales — sale_date, customer → ms_customers, product → ms_products, quantity, total, payment_method (cash/credit card/debit card/financing), salesperson
Lessons — student → ms_customers, instrument (Guitar/Bass/Drums/Piano/Vocals), instructor, lesson_date, duration_minutes (30/60), price

Relationships: Sales reference Products and Customers. Lessons reference Customers.