Micron Technology Interview Question

2 Medium level sql query and about projects