Competitive Panda
Competitive Panda
  • 9
  • 144 471
Hakerrank SQL Certification Solutions 02 [Hackerrank Certifications Solutions]
Hackerrank basic SQL certification solutions with basic SQL quarries. Get certified with hakerrank SQL certification to add more colors to your CV and make your career path successful.
Thanks for watching the video.
#SQL #Hackerrank #HackerrankCertifications
Please Subscribe for more videos.
มุมมอง: 6 355

วีดีโอ

Hakerrank SQL Intermediate Certification Solutions 02 [Hackerrank Certifications Solutions]
มุมมอง 17K3 ปีที่แล้ว
Hackerrank Intermediate SQL certification solutions with basic SQL quarries, Sub quarries and Aggregation functions. Get certified with hakerrank SQL Intermediate certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #SQL #Hackerrank #HackerrankCertifications Please Subscribe for more videos.
Hackerrank Java Certification Solutions [Hackerrank Certifications Solutions]
มุมมอง 24K3 ปีที่แล้ว
Hackerrank Basic Java certification solutions with Stack Implementation, Bracket(Paranthasis) Balance Check, Method Overloading, Inheritance, Exception Handling, and Threads. Get certified with hakerrank Java Basic certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #Java #Hackerrank #HackerrankCertifications Please Subscribe for more...
Hakerrank SQL Intermediate Certification Solutions 01 [Hackerrank Certifications Solutions]
มุมมอง 41K3 ปีที่แล้ว
Hackerrank Intermediate SQL certification solutions with basic SQL quarries, Sub quarries and Aggregation functions. Get certified with hakerrank SQL Intermediate certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #SQL #Hackerrank #HackerrankCertifications Please Subscribe for more videos.
Hakerrank Node Intermediate Certification Solutions [Hackerrank Certifications Solutions]
มุมมอง 4.7K3 ปีที่แล้ว
Hackerrank Intermediate Node certification solutions with Sequelize, Express.js, API endpoints management, Middleware management, Package and Modules Management, Callbacks, Event Loop, Concepts behind an Event-Driven Architecture and Concurrency and File Systems. Get certified with Hakerrank Node Intermediate certification to add more colors to your CV and make your career path successful. Than...
Hakerrank Python Certification Solutions [Hackerrank Certifications Solutions]
มุมมอง 2.5K3 ปีที่แล้ว
Hackerrank Python certification solutions for Multiset Implementation and Shape classes with area method. Get certified with Hakerrank Python basic certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #Python #Hackerrank #HackerrankCertifications Please Subscribe for more videos.
Hakerrank Node Certification Solutions [Hackerrank Certifications Solutions]
มุมมอง 3.8K3 ปีที่แล้ว
Hackerrank Node certification solutions with Express.js API endpoints management, Package and Modules Management, Callbacks, Event Loop, Event Emitter, Buffers, Streams and File Systems. Get certified with Hakerrank Node basic certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #Node #Hackerrank #HackerrankCertifications Please Subscr...
Hackerrank React Certification Solutions [Hackerrank Certifications Solutions]
มุมมอง 24K3 ปีที่แล้ว
Hakerrank React basic certification solutions with react hooks and functional components. Get certified with hakerrank react certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #React​ #Hackerrank​ #HackerrankCertifications​ #HackerrankSolutions Please Subscribe for more videos.
Hakerrank SQL Certification Solutions 01 [Hackerrank Certifications Solutions]
มุมมอง 21K3 ปีที่แล้ว
Hackerrank basic SQL certification solutions with basic SQL quarries. Get certified with hakerrank SQL certification to add more colors to your CV and make your career path successful. Thanks for watching the video. #SQL #Hackerrank #HackerrankCertifications Please Subscribe for more videos.

ความคิดเห็น

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

    From where we should practice please provide hacker rank link

  • @madhavanand756
    @madhavanand756 ปีที่แล้ว

    import React from 'react'; function Slides({slides}) { const [activeState, setActiveState] = React.useState(0); const reset = () => setActiveState(0) const next = () => setActiveState(n => n + 1) const prev = () => setActiveState(n => n - 1) return ( <div> <div id="navigation" className="text-center"> <button data-testid="button-restart" className="small outlined" onClick={reset} disabled={activeState===0}>Restart</button> <button data-testid="button-prev" className="small" onClick={prev} disabled={activeState===0}>Prev</button> <button data-testid="button-next" className="small" onClick={next} disabled={activeState===slides.length-1}>Next</button> </div> <div id="slide" className="card text-center"> <h1 data-testid="title">{slides[activeState].title}</h1> <p data-testid="text">{slides[activeState].text}</p> </div> </div> ); } export default Slides;

  • @manavmehta6928
    @manavmehta6928 ปีที่แล้ว

    Please if possible write the code in the description

  • @VinayKumarPandey782
    @VinayKumarPandey782 ปีที่แล้ว

    In the first problem, can we use an inner join instead of the left outer join? If not, why? I anyone knows it, please tell me, it would be of great help to me

  • @chamodyamadhushani7724
    @chamodyamadhushani7724 ปีที่แล้ว

  • @chamodyamadhushani7724
    @chamodyamadhushani7724 ปีที่แล้ว

    👍🏻👍🏻👍🏻👍🏻

  • @chamodyamadhushani7724
    @chamodyamadhushani7724 ปีที่แล้ว

    Good job ❤

  • @HARI-iy5uv
    @HARI-iy5uv ปีที่แล้ว

    ❤️

  • @ragnarlodhbrok1684
    @ragnarlodhbrok1684 ปีที่แล้ว

    hello, I used everything except for the last part, why are we counting customer id from customer table for number of count,,,is it okay to count id of contact table instead of customer id from customers...please explain

    • @ragnarlodhbrok1684
      @ragnarlodhbrok1684 ปีที่แล้ว

      how is counting number of customer id giving us the answer?very confused.... I have been learning sql for only 15 days so sorry in advance if this is a dumb question

    • @ragnarlodhbrok1684
      @ragnarlodhbrok1684 ปีที่แล้ว

      would count(*) instead of count(customer id) have given us the same result?just wondering

  • @sammyattah4653
    @sammyattah4653 ปีที่แล้ว

    Great Example. However, for the second question, after reading the file from roles.txt with the common JS fs module, you can parse the data from the callback function without splitting it. It works just the same way. just JSON.parse(data)

  • @habtamufirewenyew4486
    @habtamufirewenyew4486 ปีที่แล้ว

    it didn't work out when the index greater than the length of all slides. but good trial loved it

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

    in how many attempts you solved it?

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

    Why didn’t you use Join?

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

    6:20 react articles

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

    Awesome thanks for the overview, I completed this using a windows function but your way is much more effecient!

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

    I am getting error 1370 execute command denied to user for routine count

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

    Format average as floating point number with 6 decimal i didn't see anything about that.

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

    getting this error , can someone help expect(element).toHaveTextContent() Expected element to have text content: title 0 Received: title 1 43 | 44 | const titleElem = getByTestId(testIds.title); > 45 | expect(titleElem).toHaveTextContent(slides[0].title); | ^ 46 | 47 | const textElem = getByTestId(testIds.text); 48 | expect(textElem).toHaveTextContent(slides[0].text); at Object.<anonymous> (src/App.test.js:45:21)

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

    hi, could you try HackerRank SQL (Advanced) Skills Certification Test?

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

    bro code kiu nhi diya apne

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

    Thank you

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

    Bro can u tell me what is ei and lb here

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

      Put simply, we may construct a short name(ref) for the table using this approach. Then we may use this name along with dot operator to access table attributes.

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

    why do we have count(*) after SELECT co.country_name

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

      To get the total number of invoices by each country.

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

    Great work✨✌️

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

    one attempt not qualified means next how long will i give test after

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

      After one month, some tests can be retaken. Unfortunately, some tests are unable to retake.

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

    Java basic shape ?

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

    cannot read. the code is blur and the dark bg adds to the obscurity. it would have helped if the output window was lighter. we wouldn't have to strain our eyes to find out the code. For eg. after concat the first thing in the parenthesis is so difficult to understand. firstly it is in red and that too against a dark background. I understand the intention of this video is to help novice coders. If that is the case, then please make it available to them in a way that they can easily read and understand without much difficulty. To add to that, there's music in the bg, if there was a voiceover explaining the steps of the syntax that would have also helped in understanding the query.

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

      I appreciate your feedback. It helps me to improve my video quality. I will create upcoming videos accordingly. Thank you!

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

    Description me code daalo na help hoga students ko

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

      I cannot understand your thought. Could you please tell me in English?

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

      @@competitivepanda7615 He is suggesting you to upload the solutions in the description which will help the students more effectively(to copy-paste the code).

  • @balkrishanmahabir7982
    @balkrishanmahabir7982 3 ปีที่แล้ว

    Amazing, all others youtubers just cut and paste, but here you are aliasing the table name first, its an indication of true coder! Appricaible.

  • @SophiaHere
    @SophiaHere 3 ปีที่แล้ว

    Great solution! I came really close to the answer but got stuck because of group by. I thought I only need to group by the customer id and the user id, can you please explain in more details why do you group by all those attributes?

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Previously, All column names in the SELECT list must appear in the GROUP BY clause unless the name is used only in an aggregate function. But with the recently changed SQL standards, now it is not necessary to use all column names in the GROUP BY. You can get more details by referring to the following link, dev.mysql.com/doc/refman/8.0/en/group-by-handling.html

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

      @@competitivepanda7615 very helpful, thank you!

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

      You're welcome. Happy Coding!

  • @mandarinnu
    @mandarinnu 3 ปีที่แล้ว

    I suggest you remove the music background next time recording a tech video.

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Thanks for your feedback.

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

      you can mute the video if you dont like the music btw

  • @sameerathilakarathne5079
    @sameerathilakarathne5079 3 ปีที่แล้ว

    Superb 👌😍

  • @sameerathilakarathne5079
    @sameerathilakarathne5079 3 ปีที่แล้ว

    Nice work 👏💪

  • @amanraj-bn9kv
    @amanraj-bn9kv 3 ปีที่แล้ว

    will questions be same if i give the test one month later from now or will it differ?

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      There can be new questions or the same, because questions are selecting from question pool randomly.

  • @naveenmarasinghe
    @naveenmarasinghe 3 ปีที่แล้ว

    👍👍

  • @kaushalyailukwaththa9180
    @kaushalyailukwaththa9180 3 ปีที่แล้ว

    Good 🤟

  • @sameerathilakarathne5079
    @sameerathilakarathne5079 3 ปีที่แล้ว

    Superb...💪👌

  • @sumudusujani5731
    @sumudusujani5731 3 ปีที่แล้ว

    Nice work.😍😍

  • @jaeb4743
    @jaeb4743 3 ปีที่แล้ว

    First problem why not JOIN both tables ON c.ID = i.customer_id then HAVING SUM(i.total_price) < 588~ (>25% average was given at the bottom)

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      You have to connect customer table and invoice table. First check your references are mapped correctly.

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Source code : github.com/AshenSenevirathne/Hakerank-SQL-Intermediate-Certificatino-Solutions

    • @jaeb4743
      @jaeb4743 3 ปีที่แล้ว

      @@competitivepanda7615 sorry you’re right - didn’t see the tables. Just did this cert and it only provided 2 tables

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      For the whole solution we have connect all tables by their references. Happy Coding!🙂

  • @MahiComhd
    @MahiComhd 3 ปีที่แล้ว

    Bro how to contact u.?

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Bro, you can contact me on my Facebook page. facebook.com/Competitive-Panda-100173958938343

    • @MahiComhd
      @MahiComhd 3 ปีที่แล้ว

      @@competitivepanda7615 bro I hav texted u ppz reply me

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Sure, I will...

  • @swaradalele9637
    @swaradalele9637 3 ปีที่แล้ว

    Please update it because now its showing different questions

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Sure, I will do it. Additionally, you can access more answers by following link. github.com/AshenSenevirathne/Hakerank-SQL-Intermediate-Certificatino-Solutions

    • @swaradalele9637
      @swaradalele9637 3 ปีที่แล้ว

      Thanku

  • @hardikpandey5349
    @hardikpandey5349 3 ปีที่แล้ว

    Awesome

  • @paranormalcreation1084
    @paranormalcreation1084 3 ปีที่แล้ว

    great work keep it up..

  • @videounlock
    @videounlock 3 ปีที่แล้ว

    Hello bro hw can I contact you?

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Hello bro, you can contact me by Facebook using following link. facebook.com/Competitive-Panda-100173958938343

  • @naveenmarasinghe
    @naveenmarasinghe 3 ปีที่แล้ว

    👍👍

  • @kaushalyailukwaththa9180
    @kaushalyailukwaththa9180 3 ปีที่แล้ว

    ♥️💪

  • @kaushalyailukwaththa9180
    @kaushalyailukwaththa9180 3 ปีที่แล้ว

    💪🤟

  • @sumudusujani5731
    @sumudusujani5731 3 ปีที่แล้ว

    😍👌

  • @sameerathilakarathne5079
    @sameerathilakarathne5079 3 ปีที่แล้ว

    Great work. Keep It up bro🔥💪

  • @ahmedxavi3398
    @ahmedxavi3398 3 ปีที่แล้ว

    upload the code bro to copy it please

    • @competitivepanda7615
      @competitivepanda7615 3 ปีที่แล้ว

      Bro, You can get the source code from following link attached herewith. github.com/AshenSenevirathne/Hakerrank-Node-Intermediate-Certification-Solution.git