♨️Jobs are being posted on our freelancing group. Join fast ⏩
https://news.1rj.ru/str/freelancer_community_worldwide

HTTP Status Codes

OpenAI has now signed "multi-billion dollar deals" with:

1. US Government (Stargate) - $500 Billion
2. Nvidia - $100 Billion
3. AMD - Up to $100 Billion
4. Intel - $25 Billion
5. TSMC - $20 Billion
6. Microsoft - $13 Billion
7. Oracle - $10 Billion
8. Broadcom - "Multi-Billion"

OpenAI's valuation could exceed $1 trillion as soon as 2026.

The world's fastest growing "non-profit" will soon be engrained in every US tech giant.

The new steam age.

This is actually becoming true in many cases.

It's possible to do so much more on your own now.

Use ai tools to help you coding.

👀 Looking for talents??. Join our freelancers' community to hire

https://news.1rj.ru/str/freelancer_community_worldwide

Javanoscript  for Everything:

JS + React = Web Development
JS + Three.js = 3D Visualization
JS + Angular = Web Applications

JS + Phaser = Game Development
JS + Vue.js = Progressive Web Apps
JS + TensorFlow.js = Machine Learning

JS + Node.js = Server-Side Development
JS + Electron = DesktopApp Development
JS + React Native = MobileApp Development

#javanoscript

🚨 Localhost Issue After Recent Windows 11 Update? Here's what we know! 🚨

The recent Windows 11 update (KB5066835, dropped on Oct 14) broke "localhost" (127.0.0.1) for many, causing "ERR_CONNECTION_RESET" or pages not loading.


What’s Happening Now❔

Microsoft confirmed the bug Oct 17 and released a fix Oct 18 via a Known Issue Rollback (KIR) + a Microsoft Defender update (KB2267602). This fixed the issue for many, but it may take 48h to reach all devices. A permanent patch is still coming.


What Can You Do❔

1⃣ Update Windows: Settings > Windows Update > Check. Install, restart your PC.

2⃣ Update Defender: Windows Security(search in start) > Virus & threat protection > Check. Install, restart, test.

3⃣ Uninstall Problem Update: Still broken? Go to Settings > Windows Update > Update history > Uninstall. Find KB5066835 (KB5065789 if present), uninstall, restart, pause updates.

📌Check Microsoft’s support page for updates. Drop a comment if you’re still stuck.

PHP CHEATSHEET

⚠️😱⚠️AWS suffered a massive outage today, causing some of the most famous websites being unreachable and sending half the internet into chaos 😱

What happened ❓
A glitch in AWS’s US-East-1 region broke core DNS and database systems - reminding everyone that when Amazon sneezes, the web catches a cold.


Here is the list of all services that were not available today:

Snapchat
Ring
Robblox
My Fitness Pal
Life360
Clash Royale
Amazon
Xero
Signal
Blink Security
Wordle
HMRC
Asana
Coinbase
Duolingo
Square
Smartsheet
Jira Software
Epic Games Store
Vodafone
Atlassian
Pokémon GO
Hay Day
Amazon Alexa
Playstation Network
Peloton
Ancestry
Zoom
Brawl Stars
Dread by Daylight
Amazon Prime
IMDb
Eventbrite
Flickr
Amazon Music
Tidal
Perplexity
Rocket League
Slack
Trello
Xbox Network
EA
Ubisoft Connect
GOV UK

Here are some tricky🧩 SQL interview questions!

1. Find the second-highest salary in a table without using LIMIT or TOP.

2. Write a SQL query to find all employees who earn more than their managers.

3. Find the duplicate rows in a table without using GROUP BY.

4. Write a SQL query to find the top 10% of earners in a table.

5. Find the cumulative sum of a column in a table.

6. Write a SQL query to find all employees who have never taken a leave.

7. Find the difference between the current row and the next row in a table.

8. Write a SQL query to find all departments with more than one employee.

9. Find the maximum value of a column for each group without using GROUP BY.

10. Write a SQL query to find all employees who have taken more than 3 leaves in a month.

These questions are designed to test your SQL skills, including your ability to write efficient queries, think creatively, and solve complex problems.

Here are the answers to these questions:

1. SELECT MAX(salary) FROM table WHERE salary NOT IN (SELECT MAX(salary) FROM table)

2. SELECT e1.* FROM employees e1 JOIN employees e2 ON e1.manager_id = (link unavailable) WHERE e1.salary > e2.salary

3. SELECT * FROM table WHERE rowid IN (SELECT rowid FROM table GROUP BY column HAVING COUNT(*) > 1)

4. SELECT * FROM table WHERE salary > (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY salary) FROM table)

5. SELECT column, SUM(column) OVER (ORDER BY rowid) FROM table

6. SELECT * FROM employees WHERE id NOT IN (SELECT employee_id FROM leaves)

7. SELECT *, column - LEAD(column) OVER (ORDER BY rowid) FROM table

8. SELECT department FROM employees GROUP BY department HAVING COUNT(*) > 1

9. SELECT MAX(column) FROM table WHERE column NOT IN (SELECT MAX(column) FROM table GROUP BY group_column)