Anastasia K
Anastasia K
  • 39
  • 1 308 419
Should ChatGPT write your SQL queries? An unscientific study of how well can ChatGPT write SQL.
After playing around with ChatGPT for all my SQL wants and needs I decided it could be fun to make a video, where I ask it to do a few exercises, answer questions, and write queries typical for data analysis work and interview processes.
An important disclaimer: I think it may get better with more precise and detailed prompts, however, when I started learning how to write proper prompts, I realized that writing the query myself would be easier for me. The outcome didn't seem too enticing for me to invest so much time into fine-tuning the prompts.
So this is a raw experiment, on how a human can ask questions about SQL to ChatGPT.
Enjoy!
Переглядів: 5 957

Відео

SQL 101.4 Arrays, window functions, LAG, LEADSQL 101.4 Arrays, window functions, LAG, LEAD
SQL 101.4 Arrays, window functions, LAG, LEAD
Переглядів 1,7 тис.Рік тому
Hey there! Unlock the power of arrays and window functions in SQL for data analysis. In this tutorial, you will learn how to work with arrays and perform complex data manipulations in SQL. Discover the basics of window functions, and how they can help you analyze your data effectively. This video is perfect for beginners and intermediate users who want to expand their SQL skills and tackle more...
SQL for Data Analysis 101.3 Date and time manipulations, working with strings.SQL for Data Analysis 101.3 Date and time manipulations, working with strings.
SQL for Data Analysis 101.3 Date and time manipulations, working with strings.
Переглядів 1,4 тис.Рік тому
Hey there! Take your SQL skills to the next level with this tutorial on a basic date and time manipulations and string operations. Learn how to extract, format, and manipulate date and time values in SQL for practical data analysis. Discover various techniques to work with strings and make data transformations. Whether you are a beginner or just looking to improve your SQL knowledge, this video...
SQL for Data Analysis 101.2 CASE WHEN, IFNULL, grouping and other basic calculations.SQL for Data Analysis 101.2 CASE WHEN, IFNULL, grouping and other basic calculations.
SQL for Data Analysis 101.2 CASE WHEN, IFNULL, grouping and other basic calculations.
Переглядів 2,2 тис.Рік тому
Hey there! A long overdue follow-up to my SQL basics for data analysis video, here we'll walk through the most common groupings, CASE WHEN, IFNULL, and other frequently used calculations for data science and data analysis roles. Hope you enjoy!
Outrageous prices 💸 for food & groceries in Stockholm 🇸🇪 | A week of eating in and out for twoOutrageous prices 💸 for food & groceries in Stockholm 🇸🇪 | A week of eating in and out for two
Outrageous prices 💸 for food & groceries in Stockholm 🇸🇪 | A week of eating in and out for two
Переглядів 7 тис.Рік тому
Hi all! Wanted to give you an update on food prices in Stockholm, after I made this video about Stockholm prices. ua-cam.com/video/IlA2d44cYT0/v-deo.html Inflation is at full speed here, and the most I notice that on food prices. SO here's a little something on how much we spend on food/eating out during a week in Stockholm, as usual, you can check the prices out yourself if you look at the web...
Mental health reset: Monthly review and a trip to Vienna vlogMental health reset: Monthly review and a trip to Vienna vlog
Mental health reset: Monthly review and a trip to Vienna vlog
Переглядів 7 тис.2 роки тому
Hi there! Just wanted to vlog a bit on my trip to Vienna, to talk about the value of reflections, mental health, and how I try to sustain it in these 'unprecedented times'... Hope you enjoy it and get something valuable for yourself! :) Cheers! 00:00 Intro 03:13 Hotel Zola 06:24 Evening walk and dinner 08:44 Morning routine vibe 10:14 How I do the monthly review 16:59 Why I find it valuable for...
A week of working from home as a Data Scientist at Spotify | Stockholm, Sweden 🇸🇪A week of working from home as a Data Scientist at Spotify | Stockholm, Sweden 🇸🇪
A week of working from home as a Data Scientist at Spotify | Stockholm, Sweden 🇸🇪
Переглядів 13 тис.2 роки тому
#workweekinmylife #spotify #datascientist Hi there! Decided to pop back here with a vlog of my typical work week in Stockholm :) 00:00 Monday 05:35 Tuesday 12:55 Wednesday 17:53 Thursday 25:34 Friday Music licensed by Epidemic Sound tempura - Justnormal www.epidemicsound.com/track/KXZ9FnxaBi/ Dark Lord - Ian Luxton www.epidemicsound.com/track/HxTZedKxow/ Motivation - Henyao www.epidemicsound.co...
How I hacked my habit loop to read 30x more books in 2021 + 5 top books of 2021How I hacked my habit loop to read 30x more books in 2021 + 5 top books of 2021
How I hacked my habit loop to read 30x more books in 2021 + 5 top books of 2021
Переглядів 8 тис.2 роки тому
For someone, this may not seem like a big achievement, but I am super proud that I managed to get back into a habit of reading books! After many years of reading things I needed to, either for work or for studies, I can finally read for my own joy again! In this video, I'm sharing my book reading journey, how I accidentally experimented with the habit loop to read more and what I enjoyed readin...
Tools I use almost daily as a DS: JupyterLab, Github, BigQuery, RStudio, Cmd, Data Studio, etc.Tools I use almost daily as a DS: JupyterLab, Github, BigQuery, RStudio, Cmd, Data Studio, etc.
Tools I use almost daily as a DS: JupyterLab, Github, BigQuery, RStudio, Cmd, Data Studio, etc.
Переглядів 15 тис.2 роки тому
Hi there! Just wanted to list the tools I use often at work as a Data Scientist: Tech & Data: 1. BigQuery CLI and UI 2. Jupyter Notebook, Jupyter Lab, Sublime, Xcode, Intellij 3. RStudio 4. Git github 5. iTerm with zshell 6. Dashboard tools: RShiny, Data Studio, Tableau, Looker, QlikView Work presentation: 1. Sheets integration with BQ 2. Slides 3. Powerpoint 4. Pen and paper, or iPad and penci...
Data Science VS Machine Learning | Are you a DS if you don't do ML? | Who does ML&AI day to day?Data Science VS Machine Learning | Are you a DS if you don't do ML? | Who does ML&AI day to day?
Data Science VS Machine Learning | Are you a DS if you don't do ML? | Who does ML&AI day to day?
Переглядів 13 тис.2 роки тому
Controversial topic alert! A lot of people seem to think that being hired as a Data Scientist means that you'll deploy Machine Learning models and research AI applications. But in many companies that's not actually the case! Here I am reviewing requirements and responsibilities for "Data Scientist" roles in some of the FAANG companies, choosing those as a proxy for big tech companies with a lot...
Noise VS Bias in Data | Female Data & ML creators | You are who you want to be | Visual StorytellingNoise VS Bias in Data | Female Data & ML creators | You are who you want to be | Visual Storytelling
Noise VS Bias in Data | Female Data & ML creators | You are who you want to be | Visual Storytelling
Переглядів 15 тис.2 роки тому
Hi there! Here's what I am talking about this month: 1. Cassie Kozyrkov 1. ML course (part 1: [ua-cam.com/video/fgF6XzcK3jw/v-deo.html], part 2: [ua-cam.com/video/bk2i5AIz-us/v-deo.html]) 2. Blog - [kozyrkov.medium.com/] 2. Fullstack React with Typescript [www.newline.co/fullstack-react-with-typescript] 3. Amelia Wattenberger - D3.js book and course - [wattenberger.com/] 4. Damsel in Data - [ua...
How to nurture the ONE skill you need for confidence and successHow to nurture the ONE skill you need for confidence and success
How to nurture the ONE skill you need for confidence and success
Переглядів 11 тис.2 роки тому
I've been thinking quite a bit about what powers my confidence and motivation to achieve my goals and do challenging projects, both at work and in life. Comparing myself to colleagues and friends, I realized that the people I admire the most for taking on risks and trying new things have a specific skill or mindset in common, they have a strong feeling that they could deal with whatever comes t...
The world is not as dramatic as it seems | 5 lessons from Factfulness by Hans RoslingThe world is not as dramatic as it seems | 5 lessons from Factfulness by Hans Rosling
The world is not as dramatic as it seems | 5 lessons from Factfulness by Hans Rosling
Переглядів 8 тис.2 роки тому
Here I want to share 5 very important lessons for everyone who works with or makes decisions based on data. The quotes are taken from the book "Factfulness: Reasons We're Wrong About the World, and Why Things Are Better Than You Think" Book by Anna Rosling Rönnlund, Hans Rosling, and Ola Rosling. Some TED talks by Hans Rosling: ua-cam.com/video/hVimVzgtD6w/v-deo.html ua-cam.com/video/Sm5xF-UYgd...
Factfulness in the dramatic world | Can money buy happiness? | GROW towards your SMART goalsFactfulness in the dramatic world | Can money buy happiness? | GROW towards your SMART goals
Factfulness in the dramatic world | Can money buy happiness? | GROW towards your SMART goals
Переглядів 10 тис.3 роки тому
What I talk about: 1. "Factfulness: Ten Reasons We're Wrong About the World. And Why Things Are Better Than You Think" by Anna Rosling Rönnlund, Hans Rosling, and Ola Rosling 2. Hans Rosling TED talks: 2.1. ua-cam.com/video/hVimVzgtD6w/v-deo.html 2.2. ua-cam.com/video/Sm5xF-UYgdg/v-deo.html 3. "The Psychology of Money: Timeless lessons on wealth, greed, and happiness" by Morgan Housel 4. "Unfla...
4 reasons why you may HATE BEING a Data Scientist, but LOVE DOING Data Science4 reasons why you may HATE BEING a Data Scientist, but LOVE DOING Data Science
4 reasons why you may HATE BEING a Data Scientist, but LOVE DOING Data Science
Переглядів 36 тис.3 роки тому
There are so many different flavors of Data Scientists, the name of the role and responsibilities depend so much on the company and their level in the Data Hierarchy of needs. (medium.com/hackernoon/the-ai-hierarchy-of-needs-18f111fcc007) But, I've noticed that to get into Data Science and Analytics field, the best mindset you could have is "I want to do Data Science" rather than "I want to be ...

КОМЕНТАРІ

  • @psychologyhealingonline3939
    @psychologyhealingonline3939 24 дні тому

    We also need to talk to the employment service, the social security office, etc. why it is still very mildly said completely mathematically impossible to earn a living in the country full time and it has not improved over the decades. Fredrik

  • @effortlessjapanese123
    @effortlessjapanese123 2 місяці тому

    when are you posting again! hope you are doing well wherever you are

  • @Zoey-fu1fk
    @Zoey-fu1fk 2 місяці тому

    I failed an interview last week because I was nervous and didn't talk about my previous projects in a logical way. I'm looking for the solutions now. This is really helpful for me! Thank you so much for sharing!

  • @Nykkynn
    @Nykkynn 3 місяці тому

    1U$D = 10SEK 10 = 100 100 = 1000

  • @yayasssamminna
    @yayasssamminna 3 місяці тому

    Can you make a video about how it felt when you had just graduated?

  • @marmakadhaigal7065
    @marmakadhaigal7065 3 місяці тому

    Ur very beautiful ma'am

  • @apoorvachoudhary6579
    @apoorvachoudhary6579 3 місяці тому

    Very Informative

  • @latikabenz6289
    @latikabenz6289 3 місяці тому

    Is it very hard to bear the lack of sunshine in Sweden ?

  • @snehaagrawal8578
    @snehaagrawal8578 4 місяці тому

    Hi Ana! Thank you for making an informative video. I am planning to do my masters in Sweden and hence I have been looking for the job market and salary expectations in Sweden for quite a while and finally this video popped up and gave a lot more clarity about everything.

  • @ethelarbon6628
    @ethelarbon6628 4 місяці тому

    hello Pretty Wonderful Anastasia and Family Whatever happen you know. ❤,,,❤,,,❤,,,

  • @sharadhiurs108
    @sharadhiurs108 4 місяці тому

    Thank you! This was really helpful.

  • @pmaasca
    @pmaasca 4 місяці тому

    🚀 **Beware these 2 Silent Killers of PMO Success!** 🚀 🥷Navigating #PMO setup can be fraught with hidden dangers like overwhelming tasks, conflicting priorities, constant firefighting, and lack of clear direction. 🥷The quest for seamless integration across functions like #engineering, #finance, and #marketing adds another layer of complexity. 🔑 **Unlock PMO Excellence** 🔑 💡Hit the ground running by leveraging real-world experience. 💡Avoid reinventing the wheel with our blend of scientific frameworks and proven best practices. 💡Get the most comprehensive guide on PMO Pillars, PMO Integration, PMO Knowledge Management, and PMO Leadership. 🌟 **Why Choose Project Management Office From Basics to Brilliance Course?** 🌟 📕134 focused lectures, 📕7.5 hours of content, 📕500+ slides, and 📕400+ practical questions await! 🎉 **Special Offer on Udemy** 🎉: Transform your PMO approach from basics to brilliance! 🔖 Original $89.99, now just $36.99 for the first 100 enrollees! Don’t miss out! ⏳⏳⏳ 👉Secure your spot: www.udemy.com/course/pmaas-pmo-mastery/?couponCode=PMO100SEATS3699 #ProjectManagement #PMOIntegration #Leadership #UdemySale #PMO #ProjectManagementOffice #EnterpriseIntegration

  • @dasyaniandreschinchilla1213
    @dasyaniandreschinchilla1213 5 місяців тому

    Please, continue! We are waiting for you!

  • @BlancaDominguez-qf8yy
    @BlancaDominguez-qf8yy 6 місяців тому

    How much taxes do Swedish pay for free education?

  • @mushtaqali5845
    @mushtaqali5845 6 місяців тому

    Very informative

  • @jamalaziz9255
    @jamalaziz9255 8 місяців тому

    Really good video 👍👍

  • @belimmohsin
    @belimmohsin 8 місяців тому

    watching this video 2nd time. Really great and simple explanation, yet covering mostly every aspect from a product perspective. Thanks a lot.

  • @sherifabdellatif4485
    @sherifabdellatif4485 9 місяців тому

    Many thanks Anastasia for this nice, well-structured, and highly informative video. I am a Flutter developer too and it would be nice if you add your LinkedIn link to get connected

  • @pinakidas397
    @pinakidas397 9 місяців тому

    Damn! USA remains the best - concluded after watching this video :D

  • @wendykgosi149
    @wendykgosi149 9 місяців тому

    😫😳😕omg not what I thought it was! Sounds like a massive headache. A rabbit hole into merging with Artificial Intelligence. jeez how do humans live like this? Typical Reply “I actually enjoy some aspects of it, I like it “ 🤥

  • @MelanieAlmeida12
    @MelanieAlmeida12 9 місяців тому

    Thank you for the video, Anastasia!

  • @alvarobyrne
    @alvarobyrne 10 місяців тому

    how about that?

  • @lordbetty4806
    @lordbetty4806 11 місяців тому

    1800SEK for me and cat per month, I dont eat out.

  • @asraralam2317
    @asraralam2317 11 місяців тому

    Hi I need some help if you live near kth about accommodation please let me know how to do is wise

  • @analyticseveryday4019
    @analyticseveryday4019 11 місяців тому

    hello which editing software, camera and mic do you use? The quality is amazing

  • @romashatilovich6053
    @romashatilovich6053 Рік тому

    С удовольствием посмотрел видео. Сам мечтаю релоцироваться в Швецию. Осталось подтянуть английский и можно смело идти продакт дизайнером в компанию)

  • @miguelhermar
    @miguelhermar Рік тому

    Hello Anastasia! As a Data Scientist I admire you and love your UA-cam channel. I wanted to ask you if by any chance you know a company in Sweden that's willing to give a job permit when hiring people, or in any case open to worldwide remote opportunities. I'm looking forward to moving there, hopefully soon :) it's been a bit rough because I know some companies offer these for more experienced roles only. Any suggestion or advice would be much appreciated!

  • @user-yb3ky3nt5x
    @user-yb3ky3nt5x Рік тому

    Hi Anastasia, Thanks for sharing this very informative video. How is the job market in Stockholm for recently certified Full stack developers and data scientists with an advanced degree such as MBA?

  • @mohamedriazmohideen5516
    @mohamedriazmohideen5516 Рік тому

    in sweden

  • @mohamedriazmohideen5516
    @mohamedriazmohideen5516 Рік тому

    Hi Anastasia can you tell me which university is good to do MS in data science since i am an it professional can you please suggest

  • @apamwamba
    @apamwamba Рік тому

    Been testing it for a month or so. 3.5 does a decent job better than Bard. Wil need to test version 4 i.e paid version. But its helpful if you go through the fundamentals of SQL the HARD WAY. That way you will be able to spot mistakes. This AI is meant to assist and replace humans

  • @--INDIAN--TRADER
    @--INDIAN--TRADER Рік тому

    why did not u give upload or copy paste the sql table data of both the table and u can ask the details of order between two consecative events .. so it would have made more sense ... i think ...

  • @Gaer56
    @Gaer56 Рік тому

    I like doing research but i hate to become Excel master. I like programming and i want to make something i can use. Just more management oriented than just backend-programmer

  • @amangupta-ll3rs
    @amangupta-ll3rs Рік тому

    You not even need to write queries , Vinchi modal can generate result on the basis of natural language processing like " give me the average salary from table 1" 😅🥲

  • @ukostin123
    @ukostin123 Рік тому

    Нормально, так, Настя английский прокачала!

  • @wilhelmsarasalo3546
    @wilhelmsarasalo3546 Рік тому

    I worked in Stockholm in the 70/s as a car mechanic and assembling furniture to set up new offices. I already spoke Swedish. Then I came to California and started a software company. "Pacific Software" a DBA in L.A. County. I still run that and I have ran that remotely from Stockholm and Helsinki, both. My old Personnummer was no more, which I discovered trying to get DSL back then. I suppose they'll give me a new one. I am a Finnish citizen. California is no longer what it once was. I have ran onto corruption with no recourse. Many of my friends have left. So, I am looking around.

  • @sergejsvisockis
    @sergejsvisockis Рік тому

    5:58 - none of the EU citizens need to apply for a work permit in Sweden. The only thing which an EU citizens need to have is a valid EU passport. EU passport = residence permit. One more matter required to acquire is a personnummer. That's basically it, what's needed for an EU citizen. I myself moved to Sweden being an EU citizen and lived in couple of other EU countries being Latvian citizen. It's like that in every EU country.

  • @ilichio
    @ilichio Рік тому

    Thanks for your videos. I have a question... if I accept an offer that I know is lower than the range for that position, in how much time would you say that I would be able to renegotiate it?

  • @sweetharmony80s41
    @sweetharmony80s41 Рік тому

    Bonjour, quel est le salaire minimum en Suède 🇸🇪 ??? Merci

  • @cristinaaguilar7877
    @cristinaaguilar7877 Рік тому

    Thank you so much Anastasia for this content, I love it! 👩🏻‍💻💖

  • @wilhelmsarasalo3546
    @wilhelmsarasalo3546 Рік тому

    I lived in my van in Stockholm, but usually spent the night at a girlfriend's place.

  • @imsal1
    @imsal1 Рік тому

    Hi Anasthasia do you teach data analysis? I’m interested to learn in case if you do.

  • @Swordwarrior1000
    @Swordwarrior1000 Рік тому

    Very insightful and informative! I learned a lot. As a new comer HR professional in Stockholm, the labour law is quite vague. Thanks for the tips!

  • @klementynakwiatkowska986
    @klementynakwiatkowska986 Рік тому

    Hi girl! Long time no see, so glad to see you back! Great video, funny but I never actually used big query, so that’s a great motivation to try it out. A lot has happened since your last video, I was able to get my first data analyst job thanks to you and your advices which helped me feel more sure of myself 🎉 Hope to see you here regularly

    • @AnastasiaKVL
      @AnastasiaKVL Рік тому

      Amazing! Very happy for your new job, hope it all goes well :)

  • @whatakrispot
    @whatakrispot Рік тому

    well summarized thanks!

  • @mattworld8752
    @mattworld8752 Рік тому

    So finally our dear sister is back. 😊

  • @techwithulises
    @techwithulises Рік тому

    Excelente video 😋

  • @rentacowisgoogle
    @rentacowisgoogle Рік тому

    You can ask it some pretty complicated questions, don't be fooled. This thing will be able to teach calculus to a 2nd grader once it's able to use formulas and graphs etc. Everyone needs to approach it with clear intentions to get what they need, just in general.

  • @dikshyakasaju7541
    @dikshyakasaju7541 Рік тому

    Such an insightful video, Anastasia and the rest of your SQL videos as well. I have been doing a lot of analysis work using SQL lately and it's definitely not my strongest suit but this was such a great refresher. These functions are basically what we need and use on a daily basis. Really appreaciate the time and effort you have invested. :)

  • @tropianhs
    @tropianhs Рік тому

    Great to see you back streaming!