Posts

SQL Queries

Hello guys! Today, I practiced SQL Queries in  SQLZoo SELECT SUM(population) FROM world SELECT DISTINCT(continent) FROM world SELECT SUM(gdp) FROM world WHERE continent='Africa' SELECT COUNT(name) FROM world WHERE area>=1000000 SELECT SUM(population) FROM world WHERE name IN('Estonia', 'Latvia', 'Lithuania') SELECT continent,COUNT(name) FROM world GROUP BY continent SELECT continent,COUNT(name) FROM world WHERE population>=10000000 GROUP BY continent SELECT continent FROM world GROUP BY continent HAVING SUM(population)>=100000000

SQL Queries

 Hello guys! Today, I practiced SQL Queries in  SQLZoo . SELECT population FROM world WHERE name = 'Germany' SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway','Denmark') SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000; SELECT name FROM world WHERE population >= 200000000 SELECT name,(population/1000000) as population FROM world WHERE continent='South America' SELECT name,population FROM world WHERE name IN('France', 'Germany', 'Italy') SELECT name FROM world WHERE name LIKE 'United%' SELECT name, population, area FROM world WHERE area>3000000 AND population>250000000

Finding what are you good at

Image
Hello guys! Today I watched a Ted video " Finding what are you good at " by Drishti Sharma.  In this video, she talked about her life. She's an introverted confident girl she used to be in her childhood. In her schooling, her parents changed her school from state to central. In that school, all her classmates spoke fluently and confidently with the fluency. But she isn't able to speak like them. Her classmates after knowing this make fun of her. They didn't make friends with her.  She shared one incident that once she injured her leg in school on that day her principal came to her classroom. All her classmates got up and wished her but couldn't because of her leg injury. The Principal came to her and asked her the reason why she didn't get up. At the time she was trying to how to say her leg injury. After that, she tried to participate in all competitions in her school. She failed in the competition but at the same time, she lost her conference.  After com...

Words

Butcher-a shopkeeper who cuts up and sells meat Inhabitant- a person or animal that lives in a particular place Weaponsmith- a skilled craftsman who designs, manufactures, and repairs weapons, primarily those that are edged Sword- a weapon with a long, sharp metal blade and a handle Almanac- an annual calendar containing important dates and statistical information such as astronomical data and tide tables. Lament-to express sadness and feeling sorry about something Upended- set or turned on its end or upside down. Thrive- to grow, develop, or be successful Incorporate-  to include something as part of something larger Selcouth - odd, unusual, uncommon, or extraordinary in appearance, effect, manner, etc; peculiar

Global AI Job Market & Salary Trends 2025

Image
Hello guys! Today I analysed dataset 'Global AI Job Market & Salary Trends 2025' which is procured from Kaggle .  Top 10 Job Titles in the Dataset: job_title No.of Jobs Machine Learning Researcher 808 AI Software Engineer 784 Autonomous Systems Engineer 777 Machine Learning Engineer 772 AI Architect 771 Head of AI 765 NLP Engineer 762 Data Analyst 759 Robotics Engineer 759 AI Research Scientist 756 Jobs by Industry: industry Jobs Retail 1063 Media 1045 Automotive 1020 Consulting 1020 Technology 1011 Real Estate 1007 Government 998 Healthcare 997 Telecommunications 997 Transportation 997 Finance 984 Energy 976 Gaming 967 Manufacturing 962 Education 956 Findings: This shows that Retail and Tech companies are hiring more, while Education has fewer job opportunities in this dataset. Job Count by Experience level: Findings: Most of the jobs are for people with less experience (like freshers or junior-level). When the experience level goes up, the number of jobs goes down. This m...

Words

Decisive-making decisions quickly, efficiently, and with confidence Uncanny experience-a strange, unsettling, and often slightly frightening experience that is difficult to explain Rambling-proceeding without a specific goal, purpose, or direction Tweak-adjustment, to change something slightly, especially in order to make it more correct, effective, or suitable Lubrication-to make a process happen easily and without problems, especially by giving money Glosses over something interesting-to treat something interesting or important superficially, avoiding deep consideration or detailed exploration Delighted-feeling or showing great pleasure. Offended-upset and angry, often because someone has been rude Ripped off-to cheat someone by charging too much money, or to steal something Quest-a long search for something that is difficult to find, or an attempt to achieve something difficult

SQL Queries

use sql_store; select * from customers; select state,first_name,last_name from customers where customer_id=1; select state,first_name,last_name from customers where state='AP'; select state,first_name,last_name from customers where state like '%A'; select state,first_name,last_name from customers -- where state like '%A' order by first_name; select * from customers where customer_id=1; select * from customers -- where customer_id=1 order by first_name; select first_name,state,points from customers; select first_name,state,points,points+100 from customers; select first_name,state,points,points+100 as Points_increment from customers; select distinct state from customers; select * from customers where points>1000; select * from customers where state<>'VA'; select * from customers where state<>'VA' and last_name like '%y'; select * from products; select name,unit_price from products; select name,unit_price,unit_price*2 as new_u...

SQL Queries

Image
use sql_store; Select * from customers; insert into customers values (default,'Janani','P',null,null,'RVS','MPL','AP',default); insert into customers values (default,'Lalitha','V',null,null,'MPL','MPL','AP',570), (default,'Vyshu','V',null,null,'Kadapa','Kadapa','AP',670), (default,'Sandhya','G',null,null,'GVP','MPL','AP',590); select * from products; insert into products values (default,'Appliances-Fans',30,5.30), (default,'Appliances-Kettles',35,4.63);

Do we think differently in different languages?

Image
Today I watched a video on YouTube " Do we think differently in different languages? " By watching this video I understand that we think differently in different languages. we see different perspectives in different languages. How we see the situations or world also changes. 

How The Power Of Consistent Hard Work Can Change Your Life.

Image
Hi Guys! Today I watched a video in Josh Talks. The title name is "How The Power Of Consistent Hard Work Can Change Your Life". The speaker name is Prapti B Elizabeth. In this video she shared how she studied in school. She said that she's is a average person. She didn't get high score in all subjects except English. She likes English. So, after that she chooses English literature in Degree. After that she joined in Masters at the time she played her bills and for studies. But somehow she didn't finish her Masters because she failed in one subject. She repeatedly write her exam 4 times but she couldn't clear that exam.  After that one day her video went viral "Malayali Mother Problem". In this video, she talked Consistency, Hard work, getting out of comfort zone, love what you do and believe in yourself. 

The Power of Civil Momentum.

Image
Hello Guys! Today I watched a Ted video "The Power of Civil Momentum". The speaker name is Annamalai Kuppusamy. He worked as a IPS Officer. He is cleared that most of people saying that police people are the ones corrupted but he that's the myth but everyone believs that but that not the true. Police job also difficult that he said explain how it is.  And second thing he said public should act when something happens like in the traffic clearence, any incident happens etc. So, by doing this everything will happens on time. For ex, If the case of traffic clearence if there is few vehicles so the one of the vehicle person can came clear the traffic so there is no need to wait until the police will come to there. Incase If the one person can act at the moment then the traffic will be cleared but If that one of the persons choose to not come act there then the traffic will be increased but by the when  the police even come the situation is worst than the before. Like that he g...