סדרת 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!
שמרו את הרשימה לטבלה בבסיס נתונים ולאחר מכן הציגו:
את כל הטיפים
את השמות והכתובות של כל המסעדות
את 5 המסעדות המדורגות הכי גבוה
את 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
העבירו את הרשימה לטבלה בבסיס נתונים. נסו לחשוב איזה עמודות אתם צריכים ומה צריך להיות טיפוס הנתונים בכל עמודה. לאחר מכן:
הציגו את שמות כל החברות שמגייסות.
הציגו את החברה שמציעה את השכר הגבוה ביותר.