Joe Faulkner, whose faculty ID is 5000008, has asked that the max class size for just his ENG120 classes be decreased by 5. Before the change is implemented, the Academic Dean would like to see how this would have affected classes to which he has already been assigned. Write a query that returns the faculty ID, course ID, course title, the current max class size and the proposed new max class size of Joe’s composition classes. Make sure that the query only returns the requested information and includes a column alias for the calculated new max class size and table aliases.

Consider the following statements: #include #include class temporary { private: string description; double first; double second; public: temporary(string = "", double = 0.0, double = 0.0); void set(string, double, double); double manipulate(); void get(string& , double& , double& ); void setdescription(string); void setfirst(double); void setsecond(double); }; write the definition of the member function set() so that the instance variables are set according to the parameters. write the definition of the constructor so that it initializes the instance variables using the function set() write the definition of the member function manipulate() that returns a decimal number (double) as follows: if the value of description is "rectangle", it returns first * second if the value of description is "circle" it returns the area of a circle with radius first if the value of description is "cylinder" it returns the volume of a cylinder with radius first and height second. hint: the volume of a cylinder is simply the area of the circle at the base times the height. if the value of description is "sphere" it returns the volume of the sphere with radius first. otherwise it returns -1.0;