• בלוג
  • סדרת SQL בסיסי - פוסט 8 - תרגול היכרות עם בסיסי נתונים

סדרת SQL בסיסי - פוסט 8 - תרגול היכרות עם בסיסי נתונים

17/08/2024

היום ניקח הפסקה מחומר חדש ונתרגל את כל הפקודות שלמדנו עד עכשיו.

1. טבלת מסעדות

נתונה רשימת המסעדות הבאה:

1. La Belle Cuisine
Address: 123 Rue de Gastronomie, Paris, France
Rank: ⭐️⭐️⭐️⭐️
Expected Meal Price: €50 - €70
Date of Last Health Inspection: July 15, 2024
Useful Tip: Try the chef's special dessert; it's a local favorite!

2. Sushi Zen
Address: 456 Ocean Avenue, Tokyo, Japan
Rank: ⭐️⭐️⭐️⭐️⭐️
Expected Meal Price: ¥3,000 - ¥6,000
Date of Last Health Inspection: June 22, 2024
Useful Tip: Arrive early to get a spot at the sushi bar for an interactive experience.

3. The Rustic Grill
Address: 789 Maple Street, Austin, TX, USA
Rank: ⭐️⭐️⭐️
Expected Meal Price: $20 - $35
Date of Last Health Inspection: August 1, 2024
Useful Tip: The BBQ ribs are a must-try, especially on Wednesdays when they're half-off!

4. Pasta Paradiso
Address: 321 Via Roma, Rome, Italy
Rank: ⭐️⭐️⭐️⭐️
Expected Meal Price: €30 - €50
Date of Last Health Inspection: July 5, 2024
Useful Tip: Ask for a table on the terrace for a beautiful view of the city.

5. The Green Garden Café
Address: 123 Vegan Lane, Portland, OR, USA
Rank: ⭐️⭐️⭐️⭐️
Expected Meal Price: $15 - $25
Date of Last Health Inspection: June 30, 2024
Useful Tip: The avocado toast is a popular dish; pair it with a cold-pressed juice!

6. Le Petit Bistro
Address: 789 Rue de la Petite, Lyon, France
Rank: ⭐️⭐️⭐️⭐️⭐️
Expected Meal Price: €40 - €60
Date of Last Health Inspection: July 20, 2024
Useful Tip: Book a reservation in advance, as seating is limited and highly sought after.

7. Curry Corner
Address: 456 Spice Street, Mumbai, India
Rank: ⭐️⭐️⭐️⭐️
Expected Meal Price: ₹800 - ₹1,500
Date of Last Health Inspection: June 18, 2024
Useful Tip: Don't miss their signature butter chicken; it's a crowd-pleaser!

8. Casa del Mar
Address: 321 Beach Blvd, Barcelona, Spain
Rank: ⭐️⭐️⭐️⭐️
Expected Meal Price: €35 - €55
Date of Last Health Inspection: July 10, 2024
Useful Tip: The seafood paella is a must-try, especially with a glass of local white wine.

9. Urban Tacos
Address: 123 Downtown Avenue, Los Angeles, CA, USA
Rank: ⭐️⭐️⭐️
Expected Meal Price: $10 - $20
Date of Last Health Inspection: August 2, 2024
Useful Tip: Visit during Taco Tuesday for great deals and a lively atmosphere!

10. The Golden Wok
Address: 789 Oriental Street, Hong Kong
Rank: ⭐️⭐️⭐️⭐️
Expected Meal Price: HK$100 - HK$300
Date of Last Health Inspection: July 25, 2024
Useful Tip: The dim sum menu is extensive and delicious; try a variety for the best experience!

שמרו את הרשימה לטבלה בבסיס נתונים ולאחר מכן הציגו:

  1. את כל הטיפים

  2. את השמות והכתובות של כל המסעדות

  3. את 5 המסעדות המדורגות הכי גבוה

  4. את 5 המסעדות בהן הארוכה תהיה הכי זולה

נסו לחשוב מה יהיה טיפוס הנתונים הטוב ביותר לכל עמודה.

2. טבלת חיפוש עבודה

נתונה רשימה של מודעות דרושים:

Company Name: Tech Innovators Inc.  
Company Location: Remote  
Role: Software Engineer  
Description: Tech Innovators Inc. is seeking a skilled Software Engineer to join our growing team. You'll work on cutting-edge projects, collaborate with a talented group of developers, and contribute to building scalable and efficient software solutions.  
Requirements:  
- Proficiency in Java, Python, or C++  
- Experience with cloud technologies (AWS, Azure, GCP)  
- Strong problem-solving skills and attention to detail  
- Bachelor's degree in Computer Science or related field  
- 3+ years of professional software development experience  
Expected Pay: $100,000 - $120,000 per year  

---

Company Name: Marketing Masters  
Company Location: 123 Market Street, New York, NY  
Role: Digital Marketing Specialist  
Description: Marketing Masters is looking for a creative and analytical Digital Marketing Specialist to manage online campaigns and optimize our digital presence. The ideal candidate will have a passion for digital marketing and a strong understanding of the latest trends and tools.  
Requirements:  
- Experience with SEO, SEM, and social media advertising  
- Proficiency in Google Analytics and AdWords  
- Strong written and verbal communication skills  
- Ability to analyze data and generate actionable insights  
- 2+ years of experience in digital marketing  
Expected Pay: $60,000 - $80,000 per year  

---

Company Name: Global Enterprises  
Company Location: 456 Corporate Blvd, San Francisco, CA  
Role: Human Resources Manager  
Description: Global Enterprises is seeking a seasoned Human Resources Manager to oversee all aspects of HR practices and processes. The successful candidate will play a key role in developing HR strategies, managing employee relations, and ensuring compliance with labor laws.  
Requirements:  
- Bachelor's degree in Human Resources, Business Administration, or related field  
- Proven experience as an HR Manager or similar role  
- Knowledge of HR systems and databases  
- Excellent interpersonal and communication skills  
- Strong leadership and decision-making abilities  
Expected Pay: $90,000 - $110,000 per year  

---

Company Name: Creative Studio  
Company Location: Remote  
Role: Graphic Designer  
Description: Creative Studio is looking for a talented Graphic Designer to join our team. You will work on a variety of design projects, from digital graphics to print materials, and collaborate with other creatives to bring ideas to life.  
Requirements:  
- Proficiency in Adobe Creative Suite (Photoshop, Illustrator, InDesign)  
- Strong portfolio showcasing design skills  
- Understanding of design principles and typography  
- Excellent communication and teamwork skills  
- 2+ years of experience in graphic design  
Expected Pay: $50,000 - $70,000 per year  

---

Company Name: Fast Sales Solutions  
Company Location: 789 Sales Avenue, Chicago, IL  
Role: Sales Representative  
Description: Fast Sales Solutions is seeking a motivated Sales Representative to join our team. The ideal candidate will have a knack for building relationships, closing deals, and exceeding sales targets.  
Requirements:  
- Proven experience as a Sales Representative  
- Excellent communication and negotiation skills  
- Ability to work independently and as part of a team  
- Strong organizational and time-management skills  
- Willingness to travel  
Expected Pay: $50,000 - $75,000 per year + commission  

העבירו את הרשימה לטבלה בבסיס נתונים. נסו לחשוב איזה עמודות אתם צריכים ומה צריך להיות טיפוס הנתונים בכל עמודה. לאחר מכן:

  1. הציגו את שמות כל החברות שמגייסות.

  2. הציגו את החברה שמציעה את השכר הגבוה ביותר.