all InfoSec news
HackerRank SQL Basic Select
March 12, 2023, 5:40 a.m. | SpiffyEight77
DEV Community dev.to
Before Starting
I haven't handwritten SQL for a long time, but I have recently started practicing again to regain my skills. This post mainly records interesting problems and solutions in SQL Basic Select.
SQL Basic Select
1. Weather Observation Station 4
Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
The STATION table is described as follows:
| Field | Type |
|----------|---------------|
| ID | …
basic city find hackerrank problems select skills solutions sql station the station weather
More from dev.to / DEV Community
How to set up AWS Verified Access with Okta
11 hours ago |
dev.to
How to Hack (and secure) Serverless Applications
14 hours ago |
dev.to
Jobs in InfoSec / Cybersecurity
Information Technology Specialist II: Network Architect
@ Los Angeles County Employees Retirement Association (LACERA) | Pasadena, CA
Cybersecurity Skills Challenge -- Sponsored by DoD
@ Correlation One | United States
Security Operations Center (SOC) Analyst
@ GK Cybersecurity Group | Remote
Technical Writer Cybersecurity (Clearance Required)
@ ICF | Virginia Client Office (VA88)
Threat Management & Intelligence Expert (m/f/d)
@ METRO/MAKRO | Düsseldorf, Germany
IT Security Manager
@ Deutsche Telekom IT Solutions Slovakia | Košice, Slovakia (Slovak Republic)