Micron Technology interview question

2 Medium level sql query and about projects