Chat client database jobs
Project Name: Client Re-engagement and Scheduling Platform Project Description: The aim of this project is to develop a platform for re-engaging and scheduling appointments with previous customers using marketing techniques and AI technology. The platform will allow for the automated or manual entry of customer data from an existing database, facilitating direct and automated interaction across multiple communication channels such as WhatsApp, Telegram, email, and SMS. The objective is to schedule an appointment Key Features: Data Importation: Ability to load customer data automatically in batches or enter it manually. Communication Connectors: Utilize existing connectors and develop new ones to integrate channels like WhatsApp, Telegram, email, and Google Calendar...
...audiences on Instagram. Our proprietary software, autoigdm, enables us to streamline outreach processes and deploy AI-driven appointment setters to enhance sales engagement and conversion rates. **Job Description:** We are looking for a skilled Instagram Outreach Specialist to join our team. This role focuses on developing and executing targeted outreach strategies on Instagram, aiming to boost client engagement and sales. The ideal candidate will possess a deep understanding of Instagram’s mechanics and the ability to craft messages and campaigns that resonate with diverse audiences. **Key Responsibilities:** - Target Audience Research: Conduct detailed analysis to identify Instagram accounts across various industries that align with our clients' outreach goals. E...
I'm on the hunt for a vibrant, knowledgeable Microsoft SQL trainer for my client who can help me elevate skills to an intermediate level. Fluent Tamil communication is a must as I feel most comfortable learning in this language. Key Learnings Expected: - Database Creation: Learn how to build an efficient and well-structured database from scratch. - Querying and Managing Data: Gain expertise in extracting, manipulating, and managing data. - Advanced SQL Concepts: Explore more sophisticated SQL concepts to comprehend the language's full capabilities. Ideal Freelancer's Profile: - Experienced MS SQL tutor with a strong understanding of database creation, handling data, and advanced SQL topics. - Proficiency in teaching in Tamil. - Proven experien...
...up and configure a MySQL database with Oracle APEX. The main purpose of this setup is to manage and retrieve product inventory and sales transaction data. Key tasks include: - Designing the database to efficiently handle product inventory and sales transactions. This involves creating an Entity-Relationship Diagram (ERD), and writing Database Definition Language (DDL) and Manipulation Language (DML) statements. - Configuring the Oracle APEX environment to interact with the MySQL database and ensure smooth data retrieval and management. - Ensuring the system is secure, ensuring no unauthorized access to the database. - Providing a high-level overview of the system's architecture and functionality. Skills and experience required: - Strong expertis...
Are you seeking a professional to streamline your bank reconciliation process and ...reconciliation and financial analysis, I possess the knowledge and skills to deliver accurate and insightful results. Attention to Detail: I pride myself on my meticulous approach, ensuring that every transaction is accurately recorded and reconciled. Timely Delivery: I understand the importance of timely financial information, and I am committed to delivering results within agreed-upon deadlines. Client-Centric Approach: Your satisfaction is my priority, and I strive to provide personalized service tailored to your unique business needs. If you're ready to streamline your bank reconciliation process and gain valuable insights into your financial health, let's discuss how I can support...
As a business owner, I require a versatile freelancer who can take th...business owner, I require a versatile freelancer who can take the reins of my business, primarily in marketing and advertising, and customer support. This is a unique role that will require the selected candidate to travel across India for a month to meet with clients. Key Duties: - Overseeing and executing marketing and advertising strategies for my brand. - Providing customer support and managing client relationships. - Travelling across India for one month to meet with clients. Ideal Skills and Experience: - Extensive experience in marketing and advertising, with a focus on brand promotion. - Strong background in customer support and relationship management. - Willingness to travel extensively for business...
As the client, I'm looking for a highly skilled Laravel developer who is adept at both frontend and backend development, as well as managing and designing databases. The primary goal for this project is to build a functional web application. Your responsibilities will include: - Frontend development: Developing interactive, user-friendly interfaces that are efficient and reliable. - Backend development: Building robust, secure server-side applications that efficiently manage the logic and server response to user interactions. - Database design and management: Designing and managing a flawless database to ensure data consistency, clarity, and security. While I do have a design in mind, the developer should feel free to propose any changes or improvements to the d...
I'm looking to develop a complete HR and Projects Management system. The ideal candidate for...document exchange between team members. - Submittals Uploads: Capability for team members to upload project deliverables and submit them for review. Access and Permissions: - Admin Access: Full control over the platform and its features. - Manager Access: Ability to manage teams, projects, and HR related tasks. - Employee Access: Access to personal information, tasks, and HR related functions. - Client Access: Provision for clients to check on project progress and relevant data. The ideal candidate should have strong expertise in programming languages required for web development, experience in building similar comprehensive systems, and a good understanding of HR and project manage...
As a business owner, I require a versatile freelancer who can take th...business owner, I require a versatile freelancer who can take the reins of my business, primarily in marketing and advertising, and customer support. This is a unique role that will require the selected candidate to travel across India for a month to meet with clients. Key Duties: - Overseeing and executing marketing and advertising strategies for my brand. - Providing customer support and managing client relationships. - Travelling across India for one month to meet with clients. Ideal Skills and Experience: - Extensive experience in marketing and advertising, with a focus on brand promotion. - Strong background in customer support and relationship management. - Willingness to travel extensively for business...
I need a Laravel Expert to make two separate tasks urgently. Task 1: Wherever something specific is not specified, you have complete freedom of choice. We have a website for client X. The client wants additional functionality. The information from it is: Landing Page Creation: We develop a dedicated website page designed to collect inquiries. This page will be accessible via a QR code located on posters at the points of sale. Request Form: We embed a request form on the page where customers can enter their name and phone number and agree to the terms and conditions. We provide an option to read the general terms and conditions and a checkbox to confirm them. Request Registration: When the customer confirms their request, the information is automatic...
...an acounting application, wich are working as client-server. Basically we have on internal network a virtual windows server wich are hosting this accounting application in server mode, and the clients have a desktop accounting application (acting as a client) wich are connecting through open vpn tunnel to the virtual windows server IP. The important is that the desktop application acting as a client, in the connection setting ask the IP and the location of the server app folder ( for example the connection are D. We want to drop the open VPN server becouse is hard to maintain and generate new clients, and change to a cloudfare tunnel instead. We dont now iff can be done based on the limitations of the accountin software client wich need to point to an I...
I need a Django professional to manage a sensitive task involving the masking of our project's database. Your primary role will entail implementing encryption on our data. Key Responsibilities: - Generate an encryption key. You’ll be responsible for creating a robust and secure encryption key. - Implement Database Encryption. Utilise your Django expertise to seamlessly integrate encryption without compromising the performance or accessibility of our database. - Maintain Data Format. It is critical that the encrypted data retains its original format. Ensure that no distortions occur during this process. Ideal Skills: - Proficient in Django - Knowledgeable in database structures and encryption - Proven ability to generate secure encryption keys - Exp...
Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, ...time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what S...
...process. This process should entail a simple form requiring the user's full name, email, and contact number, followed by an email confirmation. - Client need to be able to send in information about the machine they want to sell, than our team needs to valorate how much we offer, client has to accept that offer, after offer is acepted client needs to send their machine to our office, when machine arrived we test it, if all OK, we pay the client to their bank account, wich client provides during registration process. If the machine is broken or has errors, we will deny the buy request and it will be destroyed or send back to the client ( if client accept the return shipment he needs to pay a fine of 250€ for shipment cost and tim...
I'm in need of a mid-level telecaller with experience in lead generation for Financial Services. Key Responsibilities: - Make outbound calls to potential customers and generate leads in the Financial Services industry. - Maintain a high level of professionalism and client service throughout all calls. Ideal Candidate: - Proficient in lead generation and telecalling. - Previous experience within the Financial Services industry is highly desirable. - Mid-level experience is preferred, balancing skills and cost-effectiveness.
I am looking for someone to build a specific app for iOS, for private usage only. This app will not be released widely. The primary purpose of this app will be to analyze HTTP calls for security purposes. While the app store already had apps that let me capture my HTTP traffic via an on-device VPN, I need a specif...walk me through how to deploy the app privately to my device - Some small amount of UI design, to make the UI for setting up and capturing (actually - I would be happy with just doing this by having the app retrieve a JSON or YAML config from a static URL, or via MQTT, and have nearly no UI other than "Start/Stop Capture") - Thorough knowledge of HTTP requests, their components, and the HTTP client request/response mechanism - Familiarity with MQTT, if you ...
I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.
Discussed with client to provide 1000 words Article
I am in urgent need of a professional to help me fortify the security of the videos on my WPLMS website. Currently using IDM, students can download videos. My client DOES NOT wish to use any 3rd party Video hosting services like YouTube, Screen Pal etc. All videos should get hosted in the website hosting account Key Requirements: - Implementation of Video Encryption: I need the videos on my WPLMS website to be encrypted to prevent unauthorized downloads. This is a crucial aspect of the project and must be handled with the utmost care and expertise. - Domain-Level Access Restrictions: I am also considering implementing domain-level access restrictions as an additional layer of security. This, combined with video encryption, will help in preventing unauthorized access and downloads...
write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru
As a client, I'm looking for a skilled web designer to help me create a new website. I'm open to suggestions on the type of website, it could be an e-commerce website, a portfolio website, or a blog website. I am looking for freelancers with a strong design background who can create a visually appealing and user-friendly website. The ideal freelancer should be able to: - Understand web design principles and best practices. - Create a clean, attractive, and modern design that is responsive across different devices. - Have experience designing websites that focus on user experience and usability. - Provide a portfolio of past work that demonstrates their design abilities. - Be able to communicate effectively and show attention to detail. If you're an experienced...
Need a few options of a brand style guide for a legacy brand our client has licensed. Categories are Audio, Health & Wellness, and Personal Care & Beauty. The guide should include fonts, color schemes, logo positioning, packaging structures and layouts
...it to draw IMEI numbers both randomly and from a database based on specific parameters. Key Features: - **Dual Functionality**: The tool should be capable of generating IMEI numbers randomly or by allowing me to specify certain parameters. - **Parameter Selection**: The parameters that I should be able to choose from when generating IMEI numbers are the device brand and the operating system (OS). - **Web Interface**: The tool should be accessible through a user-friendly web interface that allows me to easily generate the IMEI numbers. Skills and Experience: - Proficiency in Python, as I believe the tool can be built on existing scripts like ``. - Experience in working with databases, ideally with knowledge of the TAC database. - UI/UX design skills to create a simple an...
...competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking function on top of an existing product management database, while cleaning the existing database up and adding reporting functions. The project involves: 1. Cleaning up existing Database file of Products to a new layout (Can start again or build on existing file). 2. Adding the manufacturing cost analysis function to the database (Allows user to define ingredients and fixed costs for a product and calculate it’s cost price). 3. Adding the sub-recipe costing function – same as above, however, for internal products not sold. 4. Adding the ingredient purchase price and tracking to the database...
...should be clean, modern, and minimalistic, in line with my brand. - Contact Form: The website should have a user-friendly contact form for visitors to get in touch with me. - Subscription Sign-up: I want to enable visitors to subscribe to newsletters or updates from the site. - Project Updates: I also need a feature that allows me to post project updates, including videos and photos. - May do a client area where they can see more confidential infomration. - Should be expandable as they business grows. Ideal skills for this project include: - Proficient with modern website design principles and practices - Strong experience in UI/UX design - Experience with creating and integrating contact forms and subscription sign-ups - Ability to implement a system for posting project updat...
I'm looking to develop a Windows-based software to manage my mobile phone repair workshop. The software should be user-friendly and must include the following features: - Order Management: I need the software to allow for easy registration and tracking of all repair orders. - Client Management: The software should store essential customer information. - Service Management: It should also include a section to manage the different repair services we offer. - Inventory Control: The software should be able to keep track of the parts and supplies we have in stock. For the order management section, I specifically require: - Order Registration: I want to be able to quickly input new orders into the system. - Order Tracking: The software should help me monitor the status of each repa...
As a client, I am in need of a freelancer adept in the installation and customization of HumHub groupware on a GoDaddy shared hosting plus account. The main focus is on the User Interface setup, where expertise in layout customization is greatly needed. I battle with crafting a tailored layout that aligns with my preferences and functional needs. - Ideal Skills - Proficiency in HumHub groupware fundamentals, particularly with UI setup - Strong understanding of layout customization - Familiarity with GoDaddy's shared hosting environment Your assistance will greatly aid in completing the installation process and leveraging the software to its full potential.
...checkout. - Messaging and Communication: The website will also incorporate a chat communication system. This system should allow real-time messaging, group chat functionality, and file sharing/image uploading. The design of this chat system should be similar to Skype's messaging functionality. Ideal Skills and Experience: - Proficient in Laravel: You should be very comfortable working with Laravel and have a strong background in building e-commerce platforms and chat systems. - E-commerce Experience: Experience with payment gateways, shopping carts, and product filters is a must. - Strong Understanding of Chat Systems: Prior experience in building chat systems with functionalities like real-time messaging, group chat, and file shari...
I need a website for my construction business. It should be elegant and professional in design, with the primary purpose of showcasing our projects and services. Key Sections: - Project Showcase: This should be the highlight of the website, featuring our best and most recent projects. Each project should have its own page, with images, descriptions, and possibly client testimonials. - About Us: A section that provides information about our company's history, values, and team members. - Contact Information: An easily accessible page with our contact details, such as phone number, email, and possibly a contact form. Ideal Skills and Experience: - Proven experience in web design, particularly portfolio websites. - Understanding of the construction industry or related fields. - S...
...Navigation: The site should be user-friendly and easy to navigate, ensuring potential clients can easily find the information they need. - Mobile Responsiveness: It is crucial that the website is optimized for both mobile and desktop use. Ideal candidates for this project should have experience in Wix website development and can work with a marketing company to provide the company with the needs of the client. Previous experience creating similar sites for masonry or construction businesses would be a plus. Please provide examples of previous work in your bid. More details can be provided at a later date. His could lead to additional website design opportunities for other clients we serve. We serve small businesses that do not have their own marketing departments. While we can...
I'm seeking a seasoned digital marketer to develop and execute a holistic marketing campaign for my brand. Key Responsibilities: - Building emails for our client base to give them updates on the progress of our investments - Crafting and managing a tailored social media strategy focusing on LinkedIn, Facebook, Instagram, and Twitter. This will involve creating compelling content, managing posts, and engaging with our audience. - Devising and managing our lifecycle & one-off email marketing campaigns. This includes strategizing the email content, and handling the distribution and analysis of outcomes. - Marketing operations and being the connective secret sauce to keep all things working in marketing Skills and Experience: - Proven track record in digital marketing, wit...
I am building a website where user can upload csv and view/download content generated from backend, chat with uploaded file (e.g. ) I need just one page, landing page will include a browser box to upload a file, no authentication, no payment integration. once file uploaded, it will be processed in the backend and result will be produced in tile format (e.g. ) user can view large formats of the result by clicking over it, download it from larg/tile format. type pinaki in caps in start of your proposal. you need to focus on fuctional stuff ignore everything else from ref. () site. Tech stack: technlogy: frontend => Angular/NodeJS/(or any other tech)+HTML5 Backend is being developed by some other
I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to d...
As the client who's in search of a skilled WordPress developer, I haven't yet defined the purpose of my website—it could be a blog, e-commerce store, or a portfolio, or perhaps a blend of these. I'll need a professional to guide me through this phase and help with the selection of the most suitable domain name according to the website's ultimate purpose. I'm also open to suggestions on the kind of content that will be best suited for the website, it could either be text, images, videos, or all of it. I'll need someone experienced in developing versatile WordPress websites and able to advise me appropriately on these matters. The ideal freelancer will have: • Knowledge and experience in domain name selection. • Proficiency in WordPress...
*Responsibilities:* - Design and analyze structures for residential, commercial, and bridge projects. - Collaborate with architects and engineers to ensure designs meet standards and client requirements. - Prepare technical drawings, specifications, and reports using AutoCAD for steel structures, trusses, and Pre-Engineered Buildings (PEB). - Provide support to construction teams during implementation, ensuring structural integrity and safety. - Stay updated on industry trends, codes, and regulations related to residential, commercial, and bridge design, as well as steel structures, trusses, and PEB. *Qualifications:* - Bachelor's/Master's degree in Civil Engineering or related field. - 1-2 years of experience in structural design, with a focus on residential, commercial, ...
[Removed by Freelancer.com Admin[ *Responsibilities:* - Design and analyze structures for residential, commercial, and bridge projects. - Collaborate with architects and engineers to ensure designs meet standards and client requirements. - Prepare technical drawings, specifications, and reports using AutoCAD for steel structures, trusses, and Pre-Engineered Buildings (PEB). - Provide support to construction teams during implementation, ensuring structural integrity and safety. - Stay updated on industry trends, codes, and regulations related to residential, commercial, and bridge design, as well as steel structures, trusses, and PEB. *Qualifications:* - Bachelor's/Master's degree in Civil Engineering or related field. - 1-2 years of experience in structural design, with a...
...mijndomein using the old webshop interface. Since it is not possible to transport my website to Wordpress, it has to be rebuild. So basically, the job is about rebuilding an existing website. Though any improvements in SEO, conversion and user experience are more than welcome. The overhaul implies restructuring the framework without losing essential elements like the: - Contact form: Direct client interaction is paramount. Remodeling without losing the existing functionality is a must. - Several links to application forms (Google forms). - Testimonials: These demonstrate the value and credibility of my services. They need to remain prominent. - Blogs: Retaining these informational resources is crucial. Everything is set ( hosting, wordpress and Divi template). My current w...
Preparation of Individual Tax return ( 1040+ Schedule C) based on information provided by the client. Client will be doing Paper filing.
Hi, Devon. The $200 Lighthouse project has been approved by the client. Let me know if you have any questions. Thanks!
As the client, I'm looking for a skilled app developer to create a cross-platform app for both iOS and Android that offers a service. The app will require user accounts with profiles and personalization. Ideal Skills and Experience: - Proficiency in developing cross-platform applications for both iOS and Android - Prior experience developing and implementing user account systems with the ability for users to create profiles and personalize their experience - Understanding of user interface design and the ability to create an intuitive and efficient user experience - Strong communication skills to ensure that you can work effectively with myself as the client, understand my needs, and adapt the app to meet them. I look forward to working with you to bring this project ...
I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...
As a client looking to set up my own multiple Email Service Providers, I need a freelancer with expertise in setting up Learning Power MTA and a variety of SMTP services. Key Responsibilities: - Set up Learning Power MTA - Multiple ESP (such as MailChimp, Constant Contact, SendGrid) integration - Setting up various SMTP servers. Ideal Skills and Experience: - Proficiency in Learning Power MTA setup. - Extensive experience with various ESPs. - Ability to work with a range of SMTP services. - Strong communication skills. - Attention to detail and ability to meet tight deadlines. I'm looking for someone who can get this project done ASAP. Your expertise and efficiency are crucial.
I am looking for an experienced Data Entry Operator for a specific task. The main pur...Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer da...
...will also post previous tests give you a general idea of how the test questions will look like. The following what will be tested on: >> Introduction Chapter 1. from the textbook. - Please look at section 1.4, i.e. Delay, Loss and Throughput in Packet Switched Networks >> Application Layer, Chapter 2 from the text book. - Please look at the applications and note whether they are client-server based or peer-to-peer - Note which kind of transport layer are they using. You don't need to memorize message formats etc. No programming questions will be given on the exam. >> Transport Layer - Chapter 3 from the textbook: - Please look at basic functionality of UDP and TCP, - shown in fields of their headers, basic segment structure ...
I am in need of a professional marketer to assist me in promoting my software agency. The ideal candidate will have a strong background in social media marketing and lead generation. Key Responsibilities: - Crafting and executing a solid marketing strategy - Focusing on Facebook, Instagram, and LinkedIn - Targeting small businesses and enterprise organizations - Generating quality leads Ide...Instagram, and LinkedIn - Targeting small businesses and enterprise organizations - Generating quality leads Ideal Skills and Experience: - Proven experience in social media marketing - A successful track record in lead generation - Understanding of B2B marketing, particularly for small businesses and enterprise organizations - Excellent communication and analytical Note : paying will be per ...
...English) virtual chat operator to handle customer inquiries on our platform. Key Responsibilities: - Engage with customers in a friendly and professional manner through online chat - Provide accurate information and timely assistance to resolve customer inquiries - Maintain a positive and empathetic attitude towards customers at all times - Collaborate with team members to ensure consistent and high-quality service delivery - Adhere to company guidelines and policies while handling customer interactions Qualifications: - Native in Spanish - Great English skills (C1 level minimum) - Excellent written communication skills - Types fast (55wpm+) - Needs to have fast internet(100 download and ping below 20 minimum) - Previous customer service experience is a plus - Comfortabl...
...Atif has been tasked with designing and developing a one-page website for a client. The client has already approved the design, which is very basic and requires the website to be a single, scrollable page. Project Scope: Design Implementation: Convert the approved design into a functional website. Content Integration: Add client-provided content to the website, including text, images, and any other relevant media. Responsive Design: Ensure the website is responsive and compatible with various devices and screen sizes. Navigation: Implement smooth scrolling and a fixed navigation menu for easy access to different sections of the website. Contact Form: Include a contact form for visitors to reach out to the client. SEO Optimization: Implement basic SEO practi...
II. the task #2 (less important but fast to fix) email notifications do not work for some reason (on server with webUI @159.65...) The email sending works with cron there contains 1 task here /var/spool/cron/tabs/root and 4 here as...with small /root/) p.s. you can check working details on old server @213.168.... I. the most important but could take more time The statistics section do not work at all on the New server here is active clients on OLD server(s) (Active session menu item) http://213.168..../_new/ (click on 1st icon with Statistics) and here is an active client on new server(s) http://159.65.../_new/ when clicking stats nothing shows p.s. there will be a bonus after, for sure
Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other
