Posts

Showing posts from May, 2024

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...

SQL Queries

use sql_invoicing; select * from clients; select * from clients as c join invoices as i on c.client_id=i.client_id; select * from clients as c join invoices as i using(client_id) join payments as p using(client_id) join payment_methods as p1 on p.payment_id=p1.payment_method_id; select c.name,c.state,payment_date,payment_method,p1.name from clients as c join invoices as i using(client_id) join payments as p using(client_id) join payment_methods as p1 on p.payment_id=p1.payment_method_id; select c.name,c.state,payment_date,payment_method,p1.name from clients as c join invoices as i using(client_id) join payments as p using(client_id) join payment_methods as p1 on p.payment_id=p1.payment_method_id where state='OR';

SQL Queries

use sql_store; select * from order_items as o join products as p using(product_id); select p.name,o.order_id,o.quantity,o.unit_price from order_items as o join products as p using(product_id); select p.name,o.order_id,o.quantity,o.unit_price from order_items as o join products as p using(product_id) where quantity regexp '1$|2|3'; select * from order_items as o join sql_inventory.products as p using(product_id); select * from order_items as o join sql_inventory.products as p using(product_id) where quantity=10; use sql_hr; select * from employees; select * from employees as e join employees as m on e.reports_to=m.employee_id; select e.employee_id,e.first_name,m.first_name as manager from employees as e join employees as m on e.reports_to=m.employee_id; use sql_store; select * from customers as c join orders as o1 using(customer_id) join order_statuses as o2 on o2.order_status_id=o1.status; select o1.order_id,o1.order_date,c.first_name,c.last_name,o2.name from customers as c joi...