devxlogo

Creating a Report for a Video Store

Creating a Report for a Video Store

Question:
I have a Visual Basic project about a video store, for which I have to produce a report that includes the following:

  1. Top 10 movies last month
  2. Number of new customer accounts during last month
  3. Revenue the store had last month

Can you please help me with the above three statements?

Answer:
For the first, you can try something like this:

 SELECT MovieNameFROM Movies;GROUP BY moviename HAVING COUNT(moviename)>=10

or you can just try SET ROWCOUNT to 10. For the second, try this:

 SELECT COUNT(customer_id)FROM customersWHERE start_date > getdate()-30

Actually, you will have to play with this one if you want the month name. For example, use the CONVERT function.

Finally, you can use this for the third item:

SELECT SUM(sales) FROM storesGROUP BY store

When you get a moment, read up and study about aggregates and the group by expression.

See also  How AI Art Generators Can Save Time and Money for Startups
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist