I uploaded them. It is oracle with sqlplus
Also, could you help me with the last part of same assignment?
Generally, if you have additional work to your original question, you should enter it as a second question. This addition about triples the amount of work to be done. If you need this other part along with your original request, then I will not have the time to assist you.
When asking a question, please enter the entire question. Had I seen this other part, I would have known that I would not have enough time to assist. If you would still like the first part from your original question, just let me know. I apologize that I cannot complete all of these additional requirements for you. I simply do not have the necessary availability to provide you with the excellent service that you deserve.
Again, let me know if you would still like me to send you the first part. Have a wonderful day.
yes...thank you. please assist with 1 part
Thank you so much. Great, but what about the sql queries to answer this
1) Which movie and\or movie category has the better sales by months and\or quarters?
2) Which distributor had best or better earnings (suppose profit margin is 12% for all the distributors) by months and\or quarters??
3) Which store should be the better sale target for movie sale?
SELECT DISTINCT FIRST_VALUE(td.ORDER_MONTH) OVER (ORDER BY mof.TOTAL_SALES DESC) AS Month, FIRST_VALUE(mof.MOVIE_TITLE) OVER (ORDER BY mof.TOTAL_SALES DESC) AS TITLE, FIRST_VALUE(mof.TOTAL_SALES) OVER (ORDER BY mof.TOTAL_SALES DESC) AS SALESFROM MOVIE_ORDER_FACTS mofJOIN TIME_DIMENSION tdON mof.TIME_ID = td.TIME_ID;
what do you mean with first_value is that the name of the variable