URGENT !!!

Develop queryla.sql and querylb.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 queryia.sql: BEGIN TRAN UPDATE Sales.Customer SET ModifiedDate = '01.01.2010 WHERE CustomerlD 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)