Microsoft Interview SQL Question — Spare Server Capacity

Solving SQL Question asked by Microsoft

Suraj Mishra

·

Follow

3 min read

·

Sep 15, 2022

--

Share

Originally Published in https://asyncq.com/

Introduction

• In this article we will solve Spare Server Capacity SQL question which is asked by Microsoft as per DataLemur website.

If you don’t know DatLemur then please do visit , it’s one of the best website to practice SQL questions and improve your SQL skills.

Question

• We have been given customer, datacenter and forecasted_demand tables.
• We need to find out monthly unused server capacity for each datacenter.