C++ || STL || standard template libraries

-
Image
                                       C++ STL  1.      Pair :  Syntax :      pair <int,char> p1;     it creates a pair {2,'c'} like this.           pair <int,int> p2;     it creates a pair {2,3} like this .  Basic Code :  #include <bits/stdc++.h> using namespace std; int main() {     // cout<<"hello world\n";     pair <int,int> p1 = {1,2};     cout<<p1.first<< " "<< p1.second<<endl;          pair <int, pair<int ,char>> p2 = {1,{2,'c'}};     cout<<p2.first<<" "<<p2.second.first<<" "<<p2.second.second<<endl;          pair <int,int> arr[] = {{2,3},{4,5},{6,7}};     cout...
Post a Comment

Product Sales Analysis I || Leetcode SQL solution || Easy SQL query ✅✅✅💯💯💯🔥🔥🔥

-

                                   1068. Product Sales Analysis I 

                          || Leetcode SQL solution ||  Easy SQL query ||






Link for Question : - product sales analysis 1

SQL query :-

# Write your MySQL query statement below
select product.product_name,sales.year,sales.price
from sales inner join product 
on sales.product_id = product.product_id 
order by product.product_name asc;

Comments

Post a Comment

Popular posts from this blog

1050. Actors and Directors Who Cooperated At Least Three Times || Leetcode sql solution || Simple and Easy Approach || ✅✅✅✅💯💯💯🔥🔥🔥🔥

-
  Actors and Directors Who Cooperated At Least Three Times || Leetcode sql solution || Simple and Easy Approach || ✅✅✅✅💯💯💯🔥🔥🔥🔥 Link For The Question :   Actors and Directors Who Cooperated At Least Three Times SQL SOLUTION : USING   GROUP BY: select actor_id , director_id from ( select actor_id , director_id , count ( timestamp ) as cooperated from ActorDirector group by actor_id , director_id ) as table1 where cooperated >= 3 ; GROUP WITH HAVING CLAUSE: select actor_id , director_id from ActorDirector group by actor_id , director_id Having count ( timestamp ) >= 3 ;
Read more

Power of Millets || Happy And Healthy Life

-
Image
Foundation Day Meeting : By   D. Anjaneyulu Reddy : Power of millets: When food is right no medicine is needed. When food is wrong no medicine works 1. Cosmetologist : due to unbalanced diet, regularly going to cosmetologist 2. Harmonal imbalance : hair loss 3. 1 gm of sugar / 1 litre of blood : It is good for health. 4. Staple food : It is eaten regularly , large part of person's diet. 5. Don't eat icecream as it increase the sugar content in blood. Embrace meaning : include , hug
Read more

Typing Lesson PART-3

-
Image
  LESSON-3 qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu qwertr poiuyu Type this lesson for two days until you get  Perfection. LESSON-4 Type the below lesson with concerned Fingers qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj qawerftf p;oiujyj
Read more