Write an SQL statement that getsa count of overworked instructors for each department, subject to the following constraints:-An overworked instructor is one who has taught more than the average number of classes. Note that instructors who have not taught any classes should be included in the calculation of the average.-Listthe departments with the more overworked instructors before those with fewer overworked instructors-Use the keyword onsomewhere in your answer. -Hint: You may want to use a with clause with multiple subqueries to answer this, i. e.:with a as (select *...), b as (select * ...) select * from a, b ...

Consider the following code snippet: #ifndef cashregister_h#define cashregister_hconst double max_balance = 6000000.0; class cashregister{public: cashregister(); cashregister(double new_balance); void set_balance(double new_balance); double get_balance() const; private: double balance[12]; }; double get_monthly_balance(cashregister bk, int month); #endifwhich of the following is correct? a)the header file is correct as given. b)the definition of max_balance should be removed since header files should not contain constants. c)the definition of cashregister should be removed since header files should not contain class definitions. d)the body of the get_monthly_balance function should be added to the header file.

Suppose s, t, and w are strings that have already been created inside main. write a statement or statements, to be added to main, that will determine if the lengths of the three strings are in order by length, smallest to largest. that is, your code should determine if s is strictly shorter than t, and if t is strictly shorter than w. if these conditions hold your code should print (the boolean value) true. if not, your code should print false. (strictly means: no ties) example: if s, t, and w are "cat", "hats", and "skies" your code should print true - their lengths are 3-4-5; but if s, t, and w are "cats" "shirt", and "trust", then print false - their lengths are 4-5-5 enter your code in the box below

Anetwork security application that prevents access between a private and trusted network and other untrusted networks