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