Create the following table in your database with the following schema: Table: Sessions | Column Name | Type | session_id | duration | int | int session_id is the primary key for this table. duration is the time in seconds that a user has visited the application. Add the following data to your tables: Input: Sessions table: +----- I session_id | duration | 1 | 2 | 3 | 30 | 199 | 299 | 580 | 1000 | 5 You want to know how long a user visits your application. You decided to create bins of "[0-5>", "[5- 10>", "[10-15>", and "15 minutes or more" and count the number of sessions on it. Write an SQL query to report the (bin, total). Return the result table in any order. The results should be: Output: +--- | bin I total +-- I [0-5> | [5-10> | (10-15> | 3 | 1 | 15 or more | 1 +---

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

SQL code for:  Create a stored procedure “setRelocationFee” to set the relocation fee for a given employee. If the employee’s office is in San Francisco, the relocation fee is $10000; if the employee’s office is in Boston, the relocation fee is $8000; if the employee’s office is in London, the relocation fee is $20000; if the employee works in other offices, the relocation fee is $15000. Below is a sample statement to test your stored procedure. set @employeeID = 1501; call setRelocationFee(@employeeID, @relocationfee); select @employeeID, @relocationfee;   Having this database  CREATE TABLE `offices` (   `officeCode` varchar(10) NOT NULL,   `city` varchar(50) NOT NULL,   `phone` varchar(50) NOT NULL,   `addressLine1` varchar(50) NOT NULL,   `addressLine2` varchar(50) DEFAULT NULL,   `state` varchar(50) DEFAULT NULL,   `country` varchar(50) NOT NULL,   `postalCode` varchar(15) NOT NULL,   `territory` varchar(10) NOT NULL,   PRIMARY KEY (`officeCode`) ) ENGINE=InnoDB DEFAULT…