[MySQL] Online Judge User's Unique Total Solved Problem Query

SELECT DISTINCT sname, COUNT(verdict) AS verdict FROM ( SELECT * FROM submission where verdict='Accepted' and sname='sh...

Read More

[MySQL] After Insert Trigger Sum all value of a column

CREATE TRIGGER `mytrigger` AFTER INSERT ON `iot`  FOR EACH ROW BEGIN    DECLARE a float;    DECLARE b float;    DECLARE c float; ...

Read More

[MySql] Sort Contents based on two different value

A very important Sorting query that sort contents of a table according to two values. if values are equal based on first value then it...

Read More

First Come First Serve (FCFS) Scheduling

#include <bits/stdc++.h> using namespace std; int main() {     vector<pair<int,int> >v;     int x[100],wt[100];     //fre...

Read More

Shortest Job First (Preemptive) Scheduling in C++

#include <bits/stdc++.h> using namespace std; bool compare( const pair<long long int,long long int>& x, const pair<long ...

Read More