Develop query1a.sql and query1b.sql using Microsoft SQL Server Management Studio-AdvantureWorks2019 such that there will be a deadlock independent of order of execution of these 2 queries. Note that, once a query is executed other query should be executed immediately after it with minimal delay (in default isolation level: Read Committed). Then, suggest 2 different approaches to avoid deadlock for these queries such that first approach is fast but does not guarantees data integrity and second approach guarantees data integrity while being a bit slower. Need very soon!!!

Query details should be designed. Modify given queries below with requirements described.

Example query1a.sql:

BEGIN TRAN UPDATE Sales.Customer SET ModifiedDate = '01.01.2010' WHERE CustomerID IN (SELECT CustomerID + 5 FROM Sales.Customer WITH(REPEATABLEREAD) WHERE CustomerID BETWEEN 1 AND 5) WAITFOR DELAY '00:00:10' ROLLBACK

Example query1b.sql:

SELECT CustomerID , TerritoryID , ModifiedDate FROM Sales.Customer WHERE CustomerID IN (7,8)