Check the Windows error logs. Looks like something with SQL Server won't start.

Also, in the SQL Server install folders, there's a /log folder. Look for the errorlog that...

You haven't provided any information here.
Don't use the title, but describe the problem and errors in detail, along with what "tricks" you have used. Otherwise we may end up...

You should do some research to try and understand. Us answering these questions for an interview doesn't help you or an employer. If you have specific questions on any of...

Congrats!

You'd need a way to measure the disk udsage for all VMs/processes at the same time. When you have a hypervisor in the way, it's possible that other processes are...

When you RDP, you have a Windows login. A SQL login, or that Windows Login needs to be added to the instnace.

We don't work from screenshots. That's a cumbersome way for us to examine data and test queries.

Read the link in Thom's signature and post DDL for tables and...

You could take the projects and data from these series:
http://www.sqlservercentral.com/stairway/72494/
http://www.sqlservercentral.com/stairway/72382/

What is missing here? What don't you see? What do you not understand about the lists? You've given some requirements (though not the results you expect given that data) and...

We are happy to help, but not do the work for you. What have you done?  There are some questions and notes in the post in the T-SQL forum.

Closing. Post here: https://www.sqlservercentral.com/Forums/2014438/Can-you-help-me-on-this

Closing: Post here: https://www.sqlservercentral.com/Forums/2014438/Can-you-help-me-on-this

Merry Christmas and Happy Holidays.  Everyone be safe and enjoy time with loved ones.

http://www.sqlservercentral.com/articles/T-SQL/71571/

with cmn as (
select
  a.a
from TableA a
inner join TableB b on a.a = b.a and a.b =...