Geeky Me Library
Geeky Me Library
  • 104
  • 5 405
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
มุมมอง: 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
Practice with me : SQL Joins
มุมมอง 5821 วันที่ผ่านมา
Practice with me : SQL Joins
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
All you need to know about SQL JOINS
มุมมอง 29หลายเดือนก่อน
All you need to know about SQL JOINS
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

ความคิดเห็น

  • @sanokamcom
    @sanokamcom 10 วันที่ผ่านมา

    Thank you for making the video. This is so explanatory and better than official resources.

    • @geekymelibrary
      @geekymelibrary 10 วันที่ผ่านมา

      @@sanokamcom Thank you

  • @mathdialogue
    @mathdialogue 14 วันที่ผ่านมา

    Great insight

  • @italkaboutit
    @italkaboutit 14 วันที่ผ่านมา

    This is the reason you read whatever AI gives you again and again before using it for whatever

  • @marthasamuel
    @marthasamuel 14 วันที่ผ่านมา

    Always knew something like this would happen

  • @rishitadas4831
    @rishitadas4831 27 วันที่ผ่านมา

    I have my exam after 2 days. Thank you for explaining so clearly in under 5 minutes.

    • @geekymelibrary
      @geekymelibrary 27 วันที่ผ่านมา

      @@rishitadas4831 Thank you

  • @ssingh328
    @ssingh328 28 วันที่ผ่านมา

    Very well explained... Love from IIT Jodhpur, India. Can I get your number please???

    • @geekymelibrary
      @geekymelibrary 27 วันที่ผ่านมา

      Thank you. You can connect with me using the email in the channel description

  • @oddyys
    @oddyys หลายเดือนก่อน

    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 ?

    • @geekymelibrary
      @geekymelibrary หลายเดือนก่อน

      Thank you. I will put that in my to-do

  • @AbdulFasithMohammedIqbal
    @AbdulFasithMohammedIqbal หลายเดือนก่อน

    How can I calculate the total sales, sales per date, and the number of active users from my sales bigquery data?

    • @geekymelibrary
      @geekymelibrary หลายเดือนก่อน

      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.

  • @Bibbatron
    @Bibbatron หลายเดือนก่อน

    Thank you so much

  • @firstlast-ep5ru
    @firstlast-ep5ru 2 หลายเดือนก่อน

    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?

    • @geekymelibrary
      @geekymelibrary 2 หลายเดือนก่อน

      Yes, your conclusion is correct. We are infact saying that greedy performs greater than or at least equals any optimal solution

  • @PrathmeshBangar-f3v
    @PrathmeshBangar-f3v 3 หลายเดือนก่อน

    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

    • @geekymelibrary
      @geekymelibrary 2 หลายเดือนก่อน

      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.

  • @famueduyou
    @famueduyou 5 หลายเดือนก่อน

    Amazing :)

  • @italkaboutit
    @italkaboutit 8 หลายเดือนก่อน

    Well explained.

  • @abuchiangel7619
    @abuchiangel7619 2 ปีที่แล้ว

    Very Informative