SELECT
S.shipment_id AS SHIPMENT_ID,
S.tracking_no AS TRACKING_NO,
Sender.full_name AS SENDER_NAME,
Receiver.full_name AS RECEIVER_NAME
FROM
Shipment S
JOIN
Customer Sender ON S.sender_id = Sender.customer_id
JOIN
Customer Receiver ON S.receiver_id = Receiver.customer_id;


Telegram - @Codemaster004

SELECT
c.name AS NAME,
c.email AS EMAIL,
COUNT(o.order_id) AS DELIVERED_COUNT,
ROUND(SUM(o.delivery_fee), 2) AS TOTAL_DELIVERY_FEE
FROM
customers c
JOIN
orders o ON c.customer_id = o.customer_id
WHERE
o.order_status = 'delivered'
GROUP BY
c.customer_id,
c.name,
c.email
HAVING
COUNT(o.order_id) >= 1
ORDER BY
DELIVERED_COUNT DESC;


Telegram - @Codemaster004

🚨 Google is Hiring! 🚨

💻 Role:
* Product Solutions Engineer
* Gurgaon, Hyderabad

🎓 Eligibility:
* Bachelor’s degree in Engineering, Computer Science, a related field, or equivalent practical experience
* Experience level: Early career professional

📌 Key Requirements:
* Experience in technical project management, stakeholder management, professional services, solution engineering, or technical consulting
* Experience in either system design or reading code (e.g., Java, C++, Python)

👇 Click below to apply:
🔗 Application Link : https://www.google.com/about/careers/applications/jobs/results/98686752104817350-product-solutions-engineer/?src=Online/LinkedIn/linkedin_us&utm_source=linkedin&utm_medium=jobposting&utm_campaign=contract


💻 Live Coding Test | Projects | Interviews | OA & Hackathons Help

📢 Join our channel: @Codemaster004

🚨  eClerx is Hiring! 🚨

💻 Role:
* Analyst
* Pune / Chandigarh, India

🎓 Eligibility:
* Batch: 2024–2026
* Qualification: Graduate (Freshers)

📌 Key Requirements:
* Salary: ₹6,00,000 to ₹7,00,000 per annum
* New mega recruitment drive format
* Strong analytical mind and orientation for detail

👇 Click below to apply:
🔗 Application Link : https://fa-ewji-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/83521


💻 Live Coding Test | Projects | Interviews | OA & Hackathons Help

📢 Join our channel: @Codemaster004

🚨 Angel One is Hiring! 🚨

💻 Role:
* SDE Intern
* Bangalore (Hybrid)

🎓 Eligibility:
* Experience: 0-1 yrs
* Open to freshers and college students with strong project portfolios

📌 Key Requirements:
* Job ID: 6440
* Work on systems handling real-time stock market data and high-value financial transactions
* Help build sub-second pipelines and contribute to AI-powered features
* Strong focus on practical execution—your college pedigree matters less than your GitHub profile
* Natural bias toward shipping, iterating, and testing code rigorously

👇 Click below to apply:
🔗 Application Link : https://angelone.mynexthire.com/employer/jobs?p=eyJwYWdlVHlwZSI6ImpkIiwiY3ZTb3VyY2UiOiJjYXJlZXJzIiwicmVxSWQiOjY0NDAsInJlcXVlc3RlciI6eyJpZCI6IiIsImNvZGUiOiIiLCJuYW1lIjoiIn0sInBhZ2UiOiJjYXJlZXJzIiwiYnVmaWx0ZXIiOi0xfQ==


💻 Live Coding Test | Projects | Interviews | OA & Hackathons Help

📢 Join our channel: @Codemaster004

🚨 Esko is Hiring! 🚨

💻 Role:
* Software Engineer

🎓 Eligibility:
* Freshers (As per tags)
* Open to early career professionals

📌 Key Requirements:
* Expected Salary: 15 to 20 LPA


👇 Click below to apply:
🔗 Application Link : https://jobs.veralto.com/global/en/job/DANVGTGLOBALR10266325EXTERNALENGLOBAL/Software-Support-Engineer-I?utm_source=linkedin&utm_medium=phenom-feeds


💻 Live Coding Test | Projects | Interviews | OA & Hackathons Help

📢 Join our channel: @Codemaster004

🚨 Akamai Technologies is Hiring! 🚨

💻 Role:
* Software Engineer
* Remote (India)

🎓 Eligibility:
* Bachelor’s degree in Computer Science or its equivalent
* Experience in software development

📌 Key Requirements:
* Experience in coding with Python on Linux
* Knowledge about Golang & C/C++
* Basic knowledge on computer networks including TCP/IP, HTTP, SSL, DNS
* Comfortable working in a Linux/Unix environment

👇 Click below to apply:
🔗 Application Link :
https://fa-extu-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/3154?utm_medium=jobboard&utm_source=linkedin

💻 Live Coding Test | Projects | Interviews | OA & Hackathons Help

📢 Join our channel: @Codemaster004

🚨 Siemens Healthineers is Hiring! 🚨

💻 Role:
* Intern - Technical
* Bangalore - Karnataka - India (Office/Site only, 5 days a week)

🎓 Eligibility:
* Experience level: Student (Not Yet Graduated)
* Pursuing or recently completed a degree in Computer Science, Engineering, or a related field

📌 Key Requirements:
* Job ID: 509052
* Basic knowledge of at least one programming language (e.g., C#, C++, Java, Python)
* Understanding of software development fundamentals and lifecycle
* Familiarity with Windows or other development environments
* Assist in design, development, testing, and debugging of software components

👇 Click below to apply:
🔗 Application Link : https://jobs.siemens-healthineers.com/en_US/searchJobs/JobDetail/509052


💻 Live Coding Test | Projects | Interviews | OA & Hackathons Help

📢 Join our channel: @Codemaster004