Sql queries examples with answers pdf free download jobs

I'm in need of professional architectural drawings for an elevator. The necessary drawings will include plan drawings and section views. The final deliverable should be in PDF format. Ideal Skills and Experience: - Expertise in architectural design - Proficient in creating detailed architectural drawings - Familiarity with elevator design specifications - Ability to deliver in specified PDF format

Need two PDF drawings convert to visio.

I'm in need of a professional who can create a web-based data entry tool for a MySQL database. This tool will handle mixed data types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MyS...types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MySQL database management - Experienced in web-based application development - Prior work on data entry and validation tools - Understanding of both text and numerical data processing Please include examples of similar projects you've completed in your ...

...extracted text. Ensure seamless integration with third-party AI services. Supported Input Formats: Image files: PNG, JPG, WEBP. Document files: PDF, scanned images, DOC. Output Formats: Export translations in a structured format (e.g., DOCX or TXT). Provide side-by-side output showing the original text and its translation. Process Automation: Automate processing for multiple pages or files. Allow users to add new comics, and the program will extract, translate, and save the output automatically. Requirements: The program must use external AI services (not create an AI from scratch). It should support integration with popular AI tools via APIs. Ensure accurate text extraction, even with stylized fonts. Ideal Skills and Experience: Experience with O...

...documents. Project Scope The application will include the following functionalities: 1. Text Input: Allow users to paste or upload text files. 2. Summarization: Generate concise summaries using pre-trained AI models. 3. Output Options: Display the summary and allow users to copy or download it. 4. Simple UI: Clean and responsive design for desktop and mobile use. Technology Stack • Backend: Python (Flask) with Hugging Face Transformers for summarization. • Frontend: HTML, CSS, JavaScript. • Hosting: Free-tier hosting platforms like Render, Heroku, or Streamlit Cloud. Deliverables 1. A fully functional web-based Text Summarization Tool. 2. User guide for operation. 3. One-time deployment and setup support. Project Timeline The project w...

I'm looking for a skilled photo editor who can enhance my water bottle images for Amazon. The main edits I need include: - Background removal: The images should have a clean, professional look with the background removed. - Color Correction: The images need to be color corrected to ensure the water bottle looks its best. - Adding Text or Graphics: I will need some text and graphics added to certain images, so experience with this is a must. All edited photos will be used for a product listing, so they need to meet Amazon's photo requirements. Please provide examples of similar work you've done in the past.

Project: Installation and Customization of Frezka Salon Management System for Lotus Flower Overview: We are looking for a skilled freelancer to set up and customize the Frezka salon management system (built with Flutter and Laravel) on our server for our Lotus Flower brand. The system will serve as a centralized solution for managing appointments, staff, and operations across multiple branches. Additionally, we require specific customizations to enhance functionality for our business needs. Scope of Work: Installation and Initial Setup: Install the Frezka salon management system on our server. Configure the system to operate under our brand name, Lotus Flower. Ensure proper integration and functionality for multiple branches. Customization Requirements: Expense Management: Add a ...

I'm looking for an Excel expert who can help me build a comprehensive report showing Actuals vs Budget vs FC vs PY. The report will primarily serve as a financial overview tool and needs to be updated daily. Key requirements include: - Proficient in Excel with advanced skills in data analysis and visualization. - Experience working with internal databases and external data feeds. - Ability to understand and interpret financial data. - Capability to create automated daily updates for the report. Please include examples of similar projects you've completed in your proposal.

I'm looking for an expert in lactation medicine to create 20 multiple choice questions for me. The questions should primarily focus on clinical practice aspects of lactation medicine, derived from a provided PDF file of lecture slide handouts. - Format: The questions need to be delivered in a Google Docs and word format. - Answer Explanations: Each question should should present a clinical scenario and come with an answer explanation of moderate detail, balancing comprehensiveness and conciseness. Ideal candidates for this project should have a strong background in lactation medicine, particularly in clinical practice, and experience in creating educational materials. Skills in clear and concise writing are essential for producing quality answer explanations.

I'm looking for a professional who can help me model a conceptual stage residential project in SketchUp. - You'll need to modify existing 3D models with proposed changes. - The level of detail required is basic, focusing on the structure and layout, rather than the interior or exterior details. Ideal candidates will have extensive experience with SketchUp and a strong understanding of residential architecture. Please include examples of previous similar projects in your bid.

...showcasing platform highlights. Options to sign in, sign up, or continue as a guest. Menu with sections: Products, About Us, Portfolio, Branches, and Client Portal. Product browsing with category filtering and portfolio examples. Checkout process with a questionnaire (except for Social Media and Software Development services, which are redirected to the sales team). Client Portal (Web & Mobile): Manage orders, subscriptions, and invoices. Track social media services (platforms, post count, photoshoot dates). Monitor software development projects (milestones, due dates, calendar, training). Schedule meetings and access live chat support. Profile management and logout. Employee Portal (Web Only): Dashboard with task statistics, bonuses, and product...

I'm looking for a talented videographer with experience in creating engaging promotional content for social media. Key Requirements: - Experience in shooting and editing live-action videos - Ability to create content that increases brand visibility and engagement on social media - Understanding of the specific requirements and best practices for different social media platforms Your proposal should include examples of similar projects you have completed in the past. Must be able to shoot in Kuala Lumpur. We are a non profit NGO

Work is done per your images. Just need in Jpg, pdf/png Thanks

Project Overview: We are seeking a professional and high-converting homepage design for our dental implant office, with a strong emphasis on lead generation. The goal is to create a website that not only reflects our brand but also encourages visitors to take immediate action. Please INCLUDE A NARRATIVE alongside your submission, outlining: -Your design choices and how they align with the goals of lead generation and brand representation -The rationale behind key elements such as color schemes, layout, content placement, and interactive features -How your design will help engage visitors, build trust, and encourage them to take action Essential Features: 1.Conversion-Optimized Design: Strategically placed elements that drive user engagement and lead to action, ensuring a ...

I need a double sided A6 leaflet designing to explain how my garage deals with insurance claims. I have the text I need on a photoshop file as well as my logo in various formats, but need someone to arrange it and add graphics to make it look sleek and professional Key Requirements: - Arrange textual content on the leaflet - Integrate my logo and branding elements - Add appropriate graphics and photographs Ideal Designer: - Has a modern and clean design approach - Prior experience in corporate and professional leaflet design - Able to source and incorporate appropriate generic photographs from the internet You will have the freedom to select colors and design elements, as I am open to your creative suggestions. The goal is to create a leaflet that communicates our insurance claim...

I'm in nee...monitoring, and delivery status updates. The site must provide users with real-time updates on their deliveries and the status of drivers. - Payment Integration: The site needs to support multiple payment methods. This includes Credit/Debit card, PayPal, and Bank Transfer. The payment system must be secure and user-friendly. Ideal Skills: - Web Development: Expertise in creating interactive and user-friendly websites. - Logistics Knowledge: Understanding of the logistics and delivery sector will be an advantage. - Payment Integration: Proficiency in integrating various payment systems into a website. - Real-Time Tracking Systems: Experience with incorporating real-time monitoring features into a website. Please provide examples of similar projects ...

I'm looking for a professional and sleek social media poster to be used primarily on Instagram for product advertisement. Key Requirements: - Design should be modern and sophisticated - Use of ...for product advertisement. Key Requirements: - Design should be modern and sophisticated - Use of clean lines and minimalist aesthetics - Ability to effectively communicate brand message through design - Experience with Instagram's visual style and requirements Ideal Skills: - Graphic Design - Branding - Social Media Marketing - Understanding of Instagram's platform and its audience The poster should not only reflect a professional and sleek style but should also grab attention and promote the product effectively. Please provide examples of your previous work tha...

...Google Forms and generates a well-formatted PDF document. The project involves integrating Google Forms with a Google Sheet, cleaning and structuring the data, and creating a customizable PDF template. The primary goal of this automated system is to streamline the process of data collection and archiving. The system should be capable of: - Structuring the data from Google Forms into a Google Sheet with predefined headers and columns. - Performing essential data cleaning tasks, which include removing duplicates, standardizing formats (e.g., dates, text), and validating data entries. - Creating a customizable PDF template to present the data in a clear and professional manner. Ideal candidates for this project should have: - Proven experience with...

...Developer for NFC Card & QR Code Payment System [ FrontEnd and Login Page ready ] We are seeking an experienced Laravel PHP Developer to build a web-based NFC Card & QR Code Payment System with the following features: Key Responsibilities: Superadmin Role Manage all Admins/multiple Businesses and Users. Oversee NFC cards, transactions, cashout requests, cash deposit requests, and virtual credit management (loading credits for users). Admin Role (for Businesses) Recharge NFC cards and handle card top-ups. Manage virtual credit received from the Superadmin. Download own business QR code Create and manage "Cashier" roles within their business. Handle deposit and cashout requests to/from Supe...

I'm in need of a classic style honey jar mock-up in Photoshop. The mock-up should be comprehensive, featuring the lid design and an appropriate background setting. Ideal Skills and Experience: - Proficiency in Photoshop and 3D modeling - Strong design skills, particularly in classic style - Experience in creating product mock-ups - Ability to create realistic background settings Please include examples of similar projects in your bid.

I'm seeking a skilled video editor to help me remove names from an MP4 Zoom recording. The names are static and appear throughout the entire video. Key Requirements: - Expertise in video editing, especially with MP4 files. - Ability to seamlessly edit out text so the transformation is completely unnoticed. - Attention to detail to ensure the final product is clean and professional. Please provide examples of similar projects you've completed in your bid. There are in total about 10 videos ... but the process is exactly the same for all.

I require a professional with experience in PDF editing and interactive design to modify a PDF document for me. The task involves the following: - Integrating 15-20 dropdown boxes into the PDF. - All dropdown boxes should allow the user to select multiple items. The content of the dropdowns will be purely text. Therefore, I am looking for someone with keen attention to detail to ensure the text is accurate and well presented. Ideal skills and experience for the job: - Proficiency in PDF editing software - Experience in creating interactive PDF documents - High attention to detail - Excellent text handling skills I need some of the boxes to have the ability to enter text with each selection.

...Tracking into two WordPress websites. The primary goal is to track PDF download button clicks and send associated metadata (destination and date) to ActiveCampaign using their Event Tracking API. Our Needs 1. Button Tracking Requirements: • Track all PDF download buttons on two WordPress websites. • Each button contains unique metadata in the form of data-* attributes: • Destination: The name of the location (e.g., country or city). • Date of Departure: A specific date tied to the PDF. • This metadata needs to be dynamically captured when a button is clicked and sent to ActiveCampaign. 2. Integration with ActiveCampaign: • Use ActiveCampaign’s Event Tracking API to send the captured metadata. • ...

I'm seeking a meticulous freelancer for a data entry task. The job entails transferring data from a 300-page PDF file into an Excel spreadsheet. The data needs to be organized into clear columns such as First Name, Last Name, Address, City, ZIP Code, and Other relevant details. Requirements: - Exceptional accuracy and attention to detail. - Experience in data organization in a clean and structured format. - Timely delivery of the completed file. The data in the PDF file is text only and has a consistent layout. If you're interested, please provide your estimated time and cost for this task. Thank you!

I'm looking for a skilled Power Apps developer who can assist in building a Power App primarily for workflow automation. The specifics of the processes to be automated have not been finalized, so flexibility and a proactive approach are key. Ideal Skills: - Proficient in Power Apps - Experience in workflow automation - Strong problem-solving abilities - Exc...primarily for workflow automation. The specifics of the processes to be automated have not been finalized, so flexibility and a proactive approach are key. Ideal Skills: - Proficient in Power Apps - Experience in workflow automation - Strong problem-solving abilities - Excellent communication skills Experience: - Prior projects involving Power Apps - Successful workflow automation projects - Examples of proactive proj...

Please Sign Up or Login to see details.

I'm seeking a seasoned Flutter developer to help me create a compelling mobile e-commerce app. Key Features: - Product Catalog: The app should be able to showcase a diverse range of products in an intuitive and user-friendly manner. - Sh...experience is crucial. The cart should be able to handle various operations like adding/removing items, updating quantities, etc. - Payment Gateway Integration: The app needs to be able to securely process transactions through reliable payment gateways. Ideal Skills: - Extensive experience with Flutter framework. - Strong understanding of e-commerce app development. - Proficient in integrating various payment gateways. - Knowledge about creating an interactive product catalog and shopping cart. Please provide examples of your previo...

I'm in need of a skilled web developer to create a comprehensive ...online courses. - User Registration and Profiles: A user-friendly registration process is essential, along with personalized profiles for each user. - Blog and Articles Section: The site needs an integrated blog to share articles and updates. - Freelance Section: A dedicated space for freelancers is required, allowing for interaction and collaboration. The ideal candidate for this project should have a strong background in web development, with specific experience in creating educational platforms. A keen understanding of user interface design and e-commerce (even though this project does not currently require a specific e-commerce platform) would be beneficial. Please provide examples of similar...

I'm looking for a professional with AutoCAD experience to help me create a general arrangement plan for laying a telecommunication submarine cable. The project requires two views: a plan view and a side view, both to be designed in A3 size using a standard template. We need the drawings by today itself. Key Requirements: - Create a layout that takes into account various underwater terrains. - Deliver final designs in both DWG and PDF formats. - Use of a standard A3 size template. - High attention to detail and precision in design. - Prior experience with submarine cable layouts is a plus. Please include relevant examples of your previous work in your bid.

...need of a skilled developer with extensive experience in Hyperledger Fabric, specifically focusing on the creation of smart contracts for supply chain tracking. Key Responsibilities: - Design and develop smart contracts that facilitate supply chain tracking - Implement features for real-time updates, transaction history, and automated alerts Ideal Skills: - Proficiency in Hyperledger Fabric and smart contract development - Experience in supply chain management systems - Strong understanding of blockchain technology and its applications in tracking and tracing assets Please note, the project revolves around the development of smart contracts that need to be efficient, reliable and capable of handling complex supply chain scenarios. Your previous work examples in this do...

I'm looking for an experienced React Native developer to build an iOS app for me. The app should include the following functionality: - User Authentication: The app should have a secure login system using email and password. The ideal freelancer for this project should have a strong background in React Native and iOS development, with proven experience in implementing user authentication systems. Please include examples of similar projects you've completed in your bid.

Website Revamp with New UI/UX Design I need a complete redesign of my current website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained

...Diversification Essay I need an essay of 2,500 words on two topics relating to finance and investments. 1) Using illustrative examples, distinguish between the interest yield and the redemption yield of a bond, and discuss the likely consequences for the above yields if the default risk of a bond increases. 2) Show, using a hypothetical example, how diversification can reduce portfolio risk and analyse how dependent is the effect of such diversification on the coefficients of correlation between returns on the various securities in the portfolio. The essay should adopt a balanced approach of both theoretical explanations and practical examples, written in a formal academic style with an introduction, body and conclusion. Please note: - A comprehensive understand...

I need an essay of 2,500 words in total on two topics relating to finance and investments. 1) Using illustrative examples, distinguish between the interest yield and the redemption yield of a bond, and discuss the likely consequences for the above yields if the default risk of a bond increases. 2) Show, using a hypothetical example, how diversification can reduce portfolio risk and analyse how dependent is the effect of such diversification on the coefficients of correlation between returns on the various securities in the portfolio. The essay should adopt a balanced approach of both theoretical explanations and practical examples, written in a formal academic style with an introduction, body and conclusion. Please note: - A comprehensive understanding of the time ...

I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Manma, Bahrain. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers worldwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for Reader and Recorder. This where you read exam content aloud to the test taker and then enter the answers as they direct. The exa...

I'm looking for an experienced WordPress web developer to create a secure, user-friendly site for my pre-recorded class videos. This site should allow for: - User Registration: With secure login, password recovery, and subscription management. - Payment Integration: Primarily through Credit/Debit Cards for monthly subscriptions. - Content Upload: Enabling me to upload my pre-recorded classes and instructional videos. The subscription system should be simple: it renews each month with the corresponding payment. I can provide examples of sites I would like to model this one after.

As a small business, I require a USA Toll-Free number with 5 extensions, set up on an urgent basis. Only requirement is that there should be Daily Change in the number. I mean that the number should b changed daily and unlimited incoming facility is required. Ideal Skills and Experience: - Knowledge and experience with setting up Toll-Free numbers - Familiarity with configuring extensions properly. -NUMBER should b changed on Daily Basis. - Proficiency with Text-to-Speech technology - Excellent communication skills for understanding requirements -Unlimited Incoming facility.

I'm in need of a skilled dressmaker to sew a casual, chiffon, maxi-style dress for me. Ideal Skills: - Expertise in sewing and dressmaking - Experience working with chiffon fabric - Ability to create a maxi-style dress Please provide examples of your previous work with similar dresses.

I am looking for a professional website designer with extensive experience in e-commerce and specifically in designing coaching websites. The primary purpose of this website is to facilitate the booking and payment for coaching sessions. Key Requirements: - A fully functional booking system: This should allow users to schedule sessions seamlessly. - A secure and reliable payment gateway: This is crucial for processing payments for the coaching sessions. - A testimonials page: This will help build credibility and trust with potential clients. Ideal Skills: - Expertise in e-commerce website design - Proficient in creating and integrating booking systems and payment gateways - Experience in designing testimonials pages - Familiarity with SEO and responsive design - Str...

One week to make a professional style website for a new restaurant and it's opening. Something a bit quick and easy but the above are a couple examples

DO NOT DESIGN THIS WITH CHATGPT OR ANY OTHER AI GENERATING SOFTWARE. Download Notes: The design must be created manually. The final design must be provided in vector format for scalability and flexibility in production. I'm looking for a modern and sleek logo for my ejuice brand that incorporates elements of ice or cold imagery. The color scheme should primarily consist of cool blues and whites. Ideal skills for this project include: - Proficiency in graphic design software - Creative thinking and ability to conceptualize modern and sleek designs - Experience in logo design, particularly for product brands - Understanding of color theory and ability to work within a specified color scheme Please include a portfolio

...values: creativity, quality, boldness, trust, empowerment, and authenticity. Business cards with a modern yet retro twist. Social media templates that align with our brand. A cohesive website design combining retro and modern aesthetics. Our Style: We want branding that stands out and showcases our unique style—a perfect blend of retro and modern. To help inspire you, we’ve put together a moodboard: [Insert a link to your moodboard here]. Budget: Our budget for this project is up to $900 USD. Future Collaboration: If the collaboration goes well, we’d love to work with you on future projects for our clients and other creative endeavors. How to Apply: Please send us: Your portfolio (including examples of branding or visual identity project...

I'm looking for a basic render of a hotel hall in the Indochine style. I will provide reference images in a PDF file. Key Requirements: - Interpret and apply the Indochine design elements - Create a basic render of the hotel hall Please follow the color schemes and design elements as specified in the PDF. The ideal freelancer for this project should have experience in interior design rendering, particularly in the Indochine style. Strong attention to detail and ability to follow provided references closely is crucial.

I'm looking for a professional to create a detailed business expense report for me. The report should be in a spreadsheet format, specifically Excel or Google Sheets. I have the spreadsheet template already and need help entering the data and attaching the receipts. Key Requirements: -Enter the receipt data, vendor, amo...receipt data, vendor, amount, location and distance from 4314 Airport Blvd, austin tx. Need the receipts copied then attached or attached in some way. - The spreadsheet should be well-organized by month, easy to navigate, and ready to submit for approval. Ideal Skills: - Strong proficiency in Excel or Google Sheets. - Excellent attention to detail. - Previous experience with creating business expense reports. Please provide examples of similar proj...

I'm seeking a seasoned Ruby on Rails developer for the maintenance and updates of an existing Business Services web application. The system is designed to manage client details, documents, and operations. Key Responsibilities: - Regular maintenance and updates of the web application - Ensuring system efficiency and functionality Ideal Skills: - Proficiency in Ruby On Rails - Experience with Docker and SQL - Previous work on Business Services systems Please note, the selected developer must be contactable and able to work during UK standard office hours.

I need a skilled developer with expertise in PayPal Payments Pro integration to implement comprehensive payment solutions on my custom-built online education marketplace. Key Requirements: - Implement PayPal Payments Pro for seamless transaction processing. - Set up payment systems for both subscriptions and one-time purchases. Our website will also take Stripe payments but this is not part of your project. Ideal Skills: - Proficiency in working with custom-built platforms. - Prior experience with PayPal Payments Pro integration. - Understanding of online marketplace dynamics and payment requirements. Please provide examples of similar projects you have completed in your bid.

I need a C# developer to add a simple function to my Illustrator plugin. The task is to incorporate the "Send to Winplot" feature as per the attached PDF file. All other functions have already been implemented. Key Requirements: - The plugin should open Winplot with the file loaded. - The file should not be saved in a specific location before opening in Winplot, it should just open directly. - There are no special conditions or checks needed before sending the file to Winplot. Ideal Skills: - Proficient in C#. - Experienced in developing Illustrator plugins. - Familiar with Winplot software. I look forward to seeing your bids.

I'm looking for a seasoned software developer to create a robust Desktop Pharmacy Management System specifically for Windows OS. This system will serve multiple functions, including Point of Sale (POS) for pharmacies, buying, selling, and managing inventory with expiry date filters. The system should support barcode scanning for both selling and stock management, and should be able to store all medications and their details. Key Features: - Comprehensive inventory management with quantity tracking and expiry date filters - POS functionality for seamless selling processes - Barcode scanning capabilities for both selling and inventory management - Storage and retrieval of all medications in the system The system should also integrate the following additional modules: - C...

I'm seeking a seasoned Android(Kotlin) & iOS(Swift) Developer, boasting a minimum of 6 years experience, to build a dynamic Android application. Key Requirements: - Extensive...functionalities - Mastery of implementing OAuth for user authentication, primarily through Google and Facebook. The primary feature of this application will be its social media integration. It should allow seamless sharing and connectivity with the aforementioned platforms. The ideal candidate will have a proven track record in developing engaging, user-friendly Android applications with robust social media capabilities. Experience in implementing security measures for OAuth and creating a smooth, secure user authentication process is essential. Please include examples of previous, s...