1. Basic SQL Select Query of Hacker Rank.

Author: neptune | 20th-Apr-2022
🏷️ #SQL #Hackerrank

Problem Statement : Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

The CITY table is described as follows:







Solution :

For this challenge, we must:

  1. Select all columns using the all-column wildcard (*).

  2. Restrict the selected rows using the WHERE clause so that only records satisfying both of the following two conditions are returned:

    • COUNTRYCODE is USA, meaning the cities are American.

    • POPULATION is greater than 100000.


Query :


SELECT * 

FROM CITY 

WHERE 

    COUNTRYCODE = 'USA' 

    AND POPULATION > 100000;


Output:



Hope you understand !!!

If you have any questions let me know in the comment section.


🏷️ Discover your Interest

#JavaScript #AI #Python #Hackerrank #Motivation #React.js #Interview #Testing #IT #SQL #Selenium #Machine learning #TCS #LeetCode #AWS #Problem Solving #Certifications #API #Java #GPT #Algorithms #Github #Projects #Jobs #Django #Microservice #Node.js #IELTS #Google #Story #Data Science #Twitter #Elon Musk #ML #Health #67501


document.addEventListener("click", function(e) { if (e.target.classList.contains("copy-btn")) { const codeBlock = e.target.closest(".code-block").querySelector("pre").innerText; // ✅ Prefer modern Clipboard API if (navigator.clipboard && navigator.clipboard.writeText) { navigator.clipboard.writeText(codeBlock).then(() => { e.target.textContent = "✅ Copied"; setTimeout(() => { e.target.textContent = "📋 Copy"; }, 2000); }).catch(err => { console.error("Clipboard write failed:", err); }); } else { // ✅ Fallback for insecure contexts / older browsers const textarea = document.createElement("textarea"); textarea.value = codeBlock; document.body.appendChild(textarea); textarea.select(); try { document.execCommand("copy"); e.target.textContent = "✅ Copied"; setTimeout(() => { e.target.textContent = "📋 Copy"; }, 2000); } catch (err) { console.error("Fallback copy failed:", err); } document.body.removeChild(textarea); } } });