Use the w3schools orders database and develop sql statements. you should test you sql statements that have been thoroughly tested in w3schools.

correct response to any of the three questions will give you full credit. if you submit correct responses for all 4 questions, you will get 1 point bonus credit.

1) suppose that you want reward the customers with $2 for each order they placed. develop an sql statement that shows the names of the customers along with the total reward that they would receive.
2) develop an sql statement to show the total order value during the year 1996. (hint: the following statement gives order value for the order with orderid = 10248 select sum(o. quantity*p. price) from orderdetails o, products p where o. productid = p. productid and orderid=10248 )
3) suppose that you want reward the customers with 2% of their total order value for all their orders placed in the year 1997. develop an sql statement that shows the names of the customers along with the total reward that they would receive.
4) develop a query to show average number of units (average quantity) sold for each product. your query should show the product name, average quantity for each product sold.

Define a class named movie. include private fields for the title,year, and name of the director. include three public functions withprototypes void movie: : settitle(cstring); , voidmovie: : setyear(int); , void movie: : setdirector(string); . includeanother function that displays all the information about a movie.write a main() function that declares a movie object namedmyfavoritemovie. set and display the object's fields.this is what i have but know its wrong since it will notcompile: #include#includeusing namespace std; //class declarationclass movie{private: string movietitle ; string movieyear; string directorname; public: void settitle(string title); void setyear(string year); void setdirector(string director); void displayinfo(); }; //class implementationvoid movie: : settitle(string title){ movietitle = title; cout< < "what is the title of themovie? "< > temp; myfavoritemovie.settitle(temp); cout< < "enter movie year"< > temp; myfavoritemovie.setyear(temp); cout< < "enter director'sname"< > temp; myfavoritemovie.setdirector(temp); //display all the data myfavoritemovie.displayinfo(); system("pause"); return 0; this code is not entirely mine someone on cramster edited my firstcode but then i try manipulating the new code and i still get acompile error message : \documents\visual studio 2008\projects\movie\movie\movie.cpp(46) : error c2679: binary '< < ' : no operator found which takes aright-hand operand of type 'std: : string' (or there is no acceptableconversion)c: \program files (x86)\microsoft visual studio9.0\vc\include\ostream(653): could be'std: : basic_ostream< _elem,_traits> & std: : operator< < > (std: : basic_ostream< _elem,_traits> & ,const char *)w