highest grade for each student | microsoft interview questions and answer sql |
highest grade for each student
microsoft interview questions and answer sql
Create statement code :
===================
Create table If Not Exists Enrollments
(student_id int,
course_id int,
grade int
);
insert into Enrollments (student_id, course_id, grade) values ('2', '2', '95') ,
('2', '3', '95'),
('1', '1', '90'),
('1', '2', '99'),
('3', '1', '80'),
('3', '2', '75'),
('3', '3', '82');
select *
from enrollments;
Need Help ? Connect With me 1:1 - https://topmate.io/dewithdhairy
Let's connect on LinkedIn : / dhirajgupta141
top interview question and answer in pyspark :
• top interview questions and answers in pys...
PySpark Installation and Setup : • Spark Installation | PySpark Installation ...
DSA In Python Interview Series : • dsa for data engineer | dsa for data analy...
PySpark Interview Series : • pyspark interview questions and answers
Pandas Interview Series : • pandas interview questions and answers
SQL Interview Series : • sql interview questions and answers
#microsoft #codingninjas #sql #dataengineers #pivot #zs #fang #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion