Movie Manager is a web and/or android-based application that assists movie theater staff in maintaining and building a movie schedule. Group project for a Database Systems class.
0
stars
0
forks
source link
As an owner, I need to see the profits generated by advertisments for a given month #13
Given a month and year, such as 'APR 2019', the procedure should use a join between the Ad and Ad_trailer to get ads that have ran within the given month.
Next, the total profit from the result is what is shown to the user.
If no profit was generated or no ad's where scheduled for the given month, the result should be 0.
This should touch the following tables