c program to clear nth bit of the number || Bitwise Operators || Problem Solving ||

-
#include <stdio.h> int main() {     int num, n, newNum;     printf("Enter any number: ");     scanf("%d", &num);     printf("Enter nth bit to clear (0-31): ");     scanf("%d", &n);     newNum = num & (~(1 << n));     printf("Number before clearing %d bit: %d (in decimal)\n", n, num);     printf("Number after clearing %d bit: %d (in decimal)\n", n, newNum);     return 0; } Logic :-  num&(~(1<<n));
Post a Comment

Percentage of users attending the contest || Leetcode solution || simple explanation ||💯💯💯💯✅✅✅🔥🔥🔥🔥

-

 

                        1633. Percentage of Users Attended a Contest


Problem:-

To find the percentage of users attending contest from users and register table 

Link for question :- click here


so we need to use group by contest_id then aggregation is performed on count(register.user_id)

Approach

select count(*)
from users

This will get the total count of the table in users is 3.

count(register.user_id)

At first group by is done on contest_id (multiple rows to single row) and aggregation is done on count(register.user_id)

SQL Solution :- 

# Write your MySQL query statement below

select register.contest_id , 
round(count(register.user_id)*100/(select count(*) from users),2) as percentage
from users inner join register 
on users.user_id = register.user_id
group by contest_id
order by percentage desc, contest_id asc;

Comments

Post a Comment

Popular posts from this blog

Merge Strings Alternatively || Leetcode Solution || Easy Approach || Simple || ✅✅✅✅💯💯💯💯🔥🔥🔥🔥

-
                    Merge Strings Alternatively 👇👇 1768 .   Merge Strings Alternately You are given two strings  word1  and  word2 . Merge the strings by adding letters in alternating order, starting with  word1 . If a string is longer than the other, append the additional letters onto the end of the merged string. Return  the merged string. Merge Strings Alternatively Example 1: Input: word1 = "abc", word2 = "pqr" Output: "apbqcr" Explanation:  The merged string will be merged as so: word1: a b c word2: p q r merged: a p b q c r Example 2: Input: word1 = "ab", word2 = "pqrs" Output: "apbqrs" Explanation:  Notice that as word2 is longer, "rs" is appended to the end. word1: a b word2: p q r s merged: a p b q r s Example 3: Input: word1 = "abcd", word2 = "pq" Output: "apbqcd" Explanation:  Notice that as word1 is longer, "cd" is appended to th
Read more

HOW TO PREPARE FOR JEE MAINS IN HOME EFFECTIVELY

-
Image
Here are some tips given by your senior yaswanth to prepare for JEE mains effectively in home it self At first you should know all things about the examination. You should pay attention in class You should develop speed and accuracy You should be honest with your work Self analysis must be there You should believe in yourself and you should be confident with your studies 1. KNOW ALL THINGS ABOUT EXAM              This exam is conducted all over   India who are going to join engineering. This is conducted by NTA .                   This exam is conducted twice a year in January and April.        PATTERN:                       The question paper contains 90 multiple choice questions in which 30 are from maths 30 are from physics and 30 are from chemistry.         In my view you should concentrate more on chemistry which is more scoring  subject         And then you can concentrate on maths and then physics which the calculations given are lengthy            SYLLABUS
Read more

1978. Employees Whose Manager Left the Company || Leetcode SQL solution || simple sql query || 🔥🔥🔥💯💯💯✅✅✅

-
Image
  Employees whose manages left their company : 👇👇👇💯  Leetcode Solution:--  Intuition To find the manager who left the company, whose salary is less than 30000 dollars Approach step 1:  filter the rows whose salary is strictly less than $30000 select * from employees where salary <= 30000   Here manager_id = 6 left the company (because it isn't in employee_id column) step 2:  we need to find the manager how left the company. This we can find by searching it in employee_id from employees table (with a sub query ). select employee_id from employees where salary <= 30000 and manager_id not in ( select employee_id from employees ) step 3:  we need to order the table by employee_id. Code # Write your MySQL query statement below select employee_id from employees where salary <= 30000 and manager_id not in ( select employee_id from employees ) order by employee_id ; Please go through my blog and find more solutions :- ))  Happy Learning
Read more