Topic is Database Management. Please solve it on MSSQL

Develop query7a.sql and query7b.sql 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 Develop query7a.sql and query7b.sql 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