How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I need some help with this need and the sql that I've

Customer Question

I need some help with this need and the sql that I've written. Thank you!
Select the top 100 customers with more than 10 receipts, assuming the table had our entire database of customers.
Select Top 100
customer_id, count(id) as cnt
From receipts
Where cnt >10
Group by customer_id
Order by cnt desc
Submitted: 1 year ago.
Category: Programming
Expert:  Richard replied 1 year ago.

Hi there and welcome

Can you tell me the issue you are having with the statement? As it looks correct, but depends on your data.

What's the error you get?

Thank you