- 104
- 5 405
Geeky Me Library
เข้าร่วมเมื่อ 22 มี.ค. 2022
Your go-to channel for learning CS, AI, new IT skills, how to resolve errors.... Hit the subscribe button and Notification bell for updates! 😀
If you need to reach out privately, email me at geekyme.mail@gmail.com
If you need to reach out privately, email me at geekyme.mail@gmail.com
All You Need To Know About SQL GROUP BY, HAVING, ORDER BY, ILIKE, LIKE KEYWORDS
Master SQL: SQL GROUP BY, HAVING, ORDER BY, ILIKE, LIKE KEYWORDS
#sql
#groupby
For the spy data: Create tables then download data to be imported on pgadmin4 from www.kaggle.com/datasets/marthadimgba/spy-agency-dataset-2024
Book data: github.com/MarthaSamuel/datasets/tree/main/book_schema
online shop data: www.kaggle.com/datasets/marthadimgba/online-shop-2024
00:00 - Introduction
00:48 - LIKE vs. ILIKE
02:05 - Case-Sensitive Search with LIKE
03:00 - Case-Insensitive Search with ILIKE
05:00 - GROUP BY
06:31 - Simple GROUP BY Example
07:50 - Applying Aggregates
08:40 - Introducing the HAVING Keyword
10:40 - ORDER BY Usage
11:45 - Building a Sample Query with JOIN
#sql
#groupby
For the spy data: Create tables then download data to be imported on pgadmin4 from www.kaggle.com/datasets/marthadimgba/spy-agency-dataset-2024
Book data: github.com/MarthaSamuel/datasets/tree/main/book_schema
online shop data: www.kaggle.com/datasets/marthadimgba/online-shop-2024
00:00 - Introduction
00:48 - LIKE vs. ILIKE
02:05 - Case-Sensitive Search with LIKE
03:00 - Case-Insensitive Search with ILIKE
05:00 - GROUP BY
06:31 - Simple GROUP BY Example
07:50 - Applying Aggregates
08:40 - Introducing the HAVING Keyword
10:40 - ORDER BY Usage
11:45 - Building a Sample Query with JOIN
มุมมอง: 28
วีดีโอ
The Business and AI Podcast: How to Navigate the AI Economy
มุมมอง 286 ชั่วโมงที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube #booktuber 00:01 - Introduction to Episode 00:53 - Key theme Discussion 02:33 - Economic Shifts Through AI Adoption 03:42 - The Critical Role of Policy Makers 05:03 - Emphasizing Lifelong Learning and Human-Centric Skills 06:42 - Relevance to a Businesses and Individuals 07:06 - Practical Ap...
The Business and AI Podcast: Where is AI headed?
มุมมอง 127 ชั่วโมงที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 00:00 - Introduction 00:42 - Key Questions About AI's Future 02:15 - Democratization of AI Tools 03:00 - Intersection of AI with Other Technologies 05:05 - Societal Impact of Prediction Technology 08:10 - Why This Matters to You 08:45 - Practical Applications 09:45 - Reflection Questions How...
The Business and AI podcast: How to Stay Ahead in an AI Dominated World
มุมมอง 2412 ชั่วโมงที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 00:00 - Introduction & Context 00:36 - Exploring how AI-driven fast-paced changes demand continuous learning. Survival vs. thriving in an AI-dominated world. 01:01 - How individuals and organizations keep up with ever-evolving AI technologies. 01:55 - AI’s Impact on Skills & Routines 02:25 -...
The Business and AI Podcast: How to Totally Transform your Business using AI
มุมมอง 1922 ชั่วโมงที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 00:00 - Introduction 🎙️ 00:24 - Key Question: Beyond Task Automation 🤖 00:52 - Incremental vs. Transformational AI 🔄 02:08 - Prediction as a Competitive Edge 📊 04:16 - Fundamental Questions for Businesses ❓ 04:42 - Shift from Reactive to Proactive Strategies 🔄➡️🔼 05:45 - Challenges of AI Tra...
The Business and AI Podcast: How AI is Redefining the Role of CEOs
มุมมอง 1323 ชั่วโมงที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 00:00 - Introduction 00:25 - AI's Role in Executive Decisions 00:57 - Tactical vs Strategic Decisions with AI 01:50 - Example: Retail Giants Leveraging AI 🛍️ 02:31 - Shift from Instinct-Driven to Data-Driven Decisions 02:56 - The Accountability Dilemma ⚖️ 03:52 - Cultural Adaptation for AI A...
The Business and AI Podcast: AI Shifts From Task Automation to Job Redesign
มุมมอง 13วันที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 00:26 - AI and Job Restructuring 00:42 - Division of Labor Between AI and Humans 01:20 - Example: Marketing with AI 01:36 - New AI Job Categories 02:20 - Industry Example: Healthcare 🩺 02:38 - Industry Example: Logistics 🚚 03:04 - Industry Example: Finance 💼 03:28 - Key Takeaways from Job Re...
The Business and AI Podcast: How To Decide What AI Is Best For
มุมมอง 11วันที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 0:01 - Key Themes Review 6:56 - Why this matters 7:28 - Relevance to Businesses and Individuals 7:58 - Practical Applications for Businesses and Individuals 8:20 - Reflection Question 1: In an era dominated by data, what is the role of human intuition in decision-making, and how can it coexi...
The Business and AI Podcast: When AI Systems Make Mistakes, Who Is Responsible?
มุมมอง 11วันที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 0:01 - Key Themes Review 7:28 - Relevance to Businesses and Individuals 7:58 - Practical Applications for Businesses and Individuals 8:58 - Reflection Question 1: How do you balance the benefits of automation with risks like loss of control or accountability? 9:16 - Reflection Question 2: As...
The Business and AI Podcast: What Happens when AI Predicts Judgment
มุมมอง 13วันที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 0:01 - Key Themes Review 7:28 - Relevance to Businesses and Individuals 7:58 - Practical Applications for Businesses and Individuals 8:28 - Reflection Question 1: What are the ethical considerations of relying on AI for judgment-intensive tasks such as hiring or criminal justice? 8:46 - Refl...
The Business and AI Podcast: How Humans can work with AI in Decision-making
มุมมอง 14วันที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 0:01 - Key Themes Review 5:27 - Relevance to Everyday Life 5:34 - Practical Applications For Businesses 6:11 - Practical Applications For Individuals 6:45 - Reflection Question 1: How do you handle situations where AI predictions conflict with your intuition or judgment? 7:18 - Reflection Qu...
SQL Operators : Union, Union All, Intersect, Intersect All, Except, Except All
มุมมอง 26วันที่ผ่านมา
Master SQL: SQL Operators For the spy data: Create tables then download data to be imported on pgadmin4 from www.kaggle.com/datasets/marthadimgba/spy-agency-dataset-2024 Book data: github.com/MarthaSamuel/datasets/tree/main/book_schema online shop data: www.kaggle.com/datasets/marthadimgba/online-shop-2024 Video Timestamp Breakdown 0:00 - Welcome and Recap from Previous Video 1:12 - Today’s Foc...
The Business and AI Podcast: How Humans can Work with AI
มุมมอง 2121 วันที่ผ่านมา
#podcast #audio #audiopodcast #thebusinessandaipodcast #books #bookreview #bookrecommendations #booktube 0:01 - Key Themes Review 6:47- Why this Should Matter to you 7:19 - Practical Takeaways for Businesses: 7:42 - Practical Takeaways for Individuals: 8:08 - Reflection Question 1: If AI handles repetitive predictions, how can you strengthen your judgment and decision-making skills? 8:29 - Refl...
The Business and AI Podcast: Why do we associate Artificial Intelligence with Human Intelligence?
มุมมอง 2621 วันที่ผ่านมา
The Business and AI Podcast: Why do we associate Artificial Intelligence with Human Intelligence?
The Business and AI Podcast: The Power of Prediction
มุมมอง 2521 วันที่ผ่านมา
The Business and AI Podcast: The Power of Prediction
The Business and AI Podcast: AI as Prediction Machine
มุมมอง 621 วันที่ผ่านมา
The Business and AI Podcast: AI as Prediction Machine
The Business and AI Podcast : Competing in the age of AI Review
มุมมอง 53หลายเดือนก่อน
The Business and AI Podcast : Competing in the age of AI Review
The Business and AI Podcast: A Leadership Mandate
มุมมอง 13หลายเดือนก่อน
The Business and AI Podcast: A Leadership Mandate
The Business and AI Podcast: Making New Rules
มุมมอง 11หลายเดือนก่อน
The Business and AI Podcast: Making New Rules
The Business and AI Podcast: Ethics of Digital Scale
มุมมอง 5หลายเดือนก่อน
The Business and AI Podcast: Ethics of Digital Scale
SQL DQL, DDL and DML - Learn How To Manipulate Database Using SQL
มุมมอง 84หลายเดือนก่อน
SQL DQL, DDL and DML - Learn How To Manipulate Database Using SQL
The Business and AI Podcast: Strategic Collisions
มุมมอง 12หลายเดือนก่อน
The Business and AI Podcast: Strategic Collisions
The Business and AI Podcast: Strategy for a New Age
มุมมอง 9หลายเดือนก่อน
The Business and AI Podcast: Strategy for a New Age
The Business and AI Podcast: Becoming an AI Company
มุมมอง 11หลายเดือนก่อน
The Business and AI Podcast: Becoming an AI Company
The Business and AI Podcast: Rearchitecting your Firm
มุมมอง 20หลายเดือนก่อน
The Business and AI Podcast: Rearchitecting your Firm
The Business and AI Podcast: The AI Factory
มุมมอง 21หลายเดือนก่อน
The Business and AI Podcast: The AI Factory
The Business and AI Podcast: Rethinking your Firm
มุมมอง 15หลายเดือนก่อน
The Business and AI Podcast: Rethinking your Firm
The Business and AI Podcast: The Age of AI
มุมมอง 15หลายเดือนก่อน
The Business and AI Podcast: The Age of AI
Thank you for making the video. This is so explanatory and better than official resources.
@@sanokamcom Thank you
Great insight
Yea
This is the reason you read whatever AI gives you again and again before using it for whatever
True
Always knew something like this would happen
😆
I have my exam after 2 days. Thank you for explaining so clearly in under 5 minutes.
@@rishitadas4831 Thank you
Very well explained... Love from IIT Jodhpur, India. Can I get your number please???
Thank you. You can connect with me using the email in the channel description
This tutorial is really helpful, can you make a video of how to connect to an external API such as a flight tracker with dialogflow cx ?
Thank you. I will put that in my to-do
How can I calculate the total sales, sales per date, and the number of active users from my sales bigquery data?
Hi, That is beyond the scope of this video, but I have a Playlist for sql to give you ideas on this. You would need the aggregate function sum, count and then group by.
Thank you so much
This was an amazing video! You have no idea how much this helped me understand the whole context. But I have one question, at the end I don't think it was that clear. You ended your proof with illustration which I understand but what about the induction proof? I'm guessing i is the last box. So how do you formally show that if greedy algorithm is better for i-1 then it will also be greater. Sorry I am just a little confused. Can you conclude saying if the assumption holds that for the first i-1 boxes, the greedy algorithm need as many trucks as the optimal. So for the last box i, if there is a place in the truck where box i-1 is in, then greedy algorithm will put it in that truck. On the other hand if the optimal solution can either do the same as the greedy algorithm or try to find a way to maximize thus wait for the next truck. This concludes that the greedy algorithm is just as good or better than any optimal solution. Is this correct?
Yes, your conclusion is correct. We are infact saying that greedy performs greater than or at least equals any optimal solution
How can we display Image in the chat I have writtent the gcp function that function returns room type room description room price and room image url I want to display the image in the chat
For now the agent builder chat app is text based. What you can do is host the images on a publicly accessible platform, and then compile the url of your images. Then add this url document to your training data.
Amazing :)
Well explained.
Very Informative
Yeah, thanks