Task3: Write SQL Queries • At least 2 queries involving GROUP BY, HAVING, and aggregate operators. • At least 2 nested queries involving IN, EXIST, op ANY, op ALL...

Translate the following pandas statement in Python to a SQL query so that it can be executed on the SQL database. dfdata[(10*dfdata['cases']>dfdata['cases'])&(dfdata['date']=='2020-10-10')]['county']

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

Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Create a procedure to calculate the VAT. 1   Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ;   Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64

Adjust the following information so that1) all users on the system are able to run the SQL Executable and 2) multiple users (such as a team of software engineers) have the power to modify the SQL Executable Introduce any new groups that are needed and assign them group IDs USERS SQL Manager UID: 3 GROUPS SQL Users GID: 5 FILESDatabase File Owner 3 Group NA owner: rw group: - world: - setUID: 0 setGID: 0 sticky: 0 SQL Executable Owner 3 Group 5 owner: rwx group: r-x world: - setUID: 1 setGID: 0 sticky: 0

06

True or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B).  * in an SQL SELECT statement means “all the tuples”.   In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator.  Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.

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

Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot.

This assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings Prerequisites: Completion of Assignment 1B, reading of Module Readings and Slides. Run the following query to understand how much Memory is currently in use in the database: SELECT   physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB,    large_page_allocations_kb/1024 AS sql_large_page_allocations_MB,    locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB,    virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB,    virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB,    virtual_address_space_available_kb/1024 AS sql_VAS_available_MB,    page_fault_count AS sql_page_fault_count,    memory_utilization_percentage AS sql_memory_utilization_percentage,    process_physical_memory_low AS sql_process_physical_memory_low,    process_virtual_memory_low AS…