Write an sql query that finds the minimum number of rooms jobber
Hello All, We are an established IT services provider with 13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. ...
...need of an app developer who can create a straightforward, yet efficient application for both iOS and Android. Key Features: - User Portal: This will be the main entry point for users. It should be user-friendly and intuitive. - Document Import: Users should be able to import documents into the application. - Document Merging: The app should have the capability to merge documents. - Text Processing: The application should be able to process text. File Formats: - The app should support the following file formats for document import: PDF, Word (docx), and text files. The ideal candidate for this job should have: - Proficient in both iOS and Android app development. - Experience with document processing and merging. ...
...with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box 4- Habitat Furniture 5- United Furniture The priority is the IKEA store. If you encounter difficulties, please proceed to the next store, Home Centre, and continue
...generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, i...
We are recruiting a skilled UI/UX designer with a minimum of 3yrs experience in the healthcare domain for a hospital management web application. Key project details: - The focus is on enhancing user experience for patients, healthcare professionals, and administrative staff. - The approach is to simplify the complex processes involved in daily operations. Ideal skills: - Proven experience in UI/UX design. - Specific experience in the healthcare industry. - Strong knowledge of user-centered design principles. - Ability to simplify complex processes while maintaining functionality. - Excellent communication skills to liaise with stakeholders from different roles in the hospital and clinic setting.
1. Introduction This specifications document outlines the requirements for developing a mobile application compatible with Android and iOS using the Flutter framework. The application will include the following features: a loading screen, a login page with Facebook login, Google login, and email/password authentication, a WebView pointing to , and integration with Wonderpush for push notifications. 2. Project Objectives To develop a user-friendly and functional mobile application that allows users to log in through multiple authentication methods and access the website via an integrated WebView. The app should also be capable of sending push notifications. 3. Required Technologies Framework: Flutter Languages: Dart Compatibi...
Rebuilding a fullscreen section in Elementor on your server Content Homepage / Fullscreen Section: Animated font Animated flipping image menu Please only report freelancers who can realize this today. It is not a very big task Thank you
Who we are Lezzat is an Amazon marketing agency based in Reading, UK and Athens, Greece. We are bunch of Amazon sellers ourselves that got frustrated with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listi...
We are a software development company that has developed password management solution. As part of our service offerings, we provide a browser extension that allows users to manage their passwords securely and conveniently. Currently, this browser extension is based on the outdated Manifest V2. The existing extension is based on Angular 1. It is working for Firefox, Chrome and the new Edge browser. To ensure compatibility with the latest browser standards, we are looking for an experienced freelancer to perform the migration of our browser extension to the latest Manifest V3. Project scope: • Analysis of the current implementation of the browser extension • Migration...
I require a talented content writer to help me develop engaging and SEO-friendly blog articles. Key Requirements: - The content should be well-researched and highly informative. - It should be optimized for search engines to help drive organic traffic. - A keen understanding of my target audience is crucial, as the articles need to be engaging and relevant to them. Ideal Skills: - Proven experience in crafting high-quality blog articles. - SEO knowledge to create content that ranks well. - Ability to write in a tone that resonates with my target audience. - Good research and analysis skills. - Understanding of effective content promotion strategies. The specific number of articles needed is yet to be determined, so I...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized ...
...plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. Prerequisites: For the long term project the *STARTING* wage will be as stat...
...seeking a dynamic and motivated individual to join our team as a Real Estate Sales Executive. The ideal candidate will have a minimum of 1-5 years of experience in real estate sales, excellent communication skills, and ability of generating leads, converting leads, and closing deals. Responsibilities: Generate leads through various channels such as networking, referrals, cold calling, and online platforms. Communicate effectively with clients to understand their needs and preferences. Conduct property tours and provide detailed information about properties to potential buyers. Negotiate and finalize sales contracts, ensuring favorable terms for both parties. Follow up with clients throughout the sales process to provide updates and address a...
...unique project as I don't want to use any tAPIs for this, so the developer would need to work from scratch. Key Project Requirements: - Design an Interactive Map: The map should be engaging, user-friendly, and provide a clear view of the restaurant locations. - Marker-based Information Display: When a marker is clicked, it should display the name of the corresponding restaurant. - Scalability: The map should be able to handle over 20 restaurant markers effectively. Ideal Skills and Experience: - Proven experience in developing interactive maps - Proficiency in working without third-party APIs - Familiarity with integrating marker-based information display - Ability to create a scalable solution that can handle ...
I'm in need of a comprehensive College Guide for Kerala that will help me to travel through Kerala and take us to college and get place to take room. This guide should include: - Take us to the college campus we provide - Take us to cheap rooms for taking rest The primary goal of this guide is to serve as a comprehensive resource for engaging us with various colleges. I'm looking for a freelancer with experience in educational research and understanding of Indian college systems. Previous work in similar projects is a big plus.
Vanakkam Editing Enthusiastic, I hope this message finds you well. I'm reaching out because I'm in search of a talented YouTube editor based in Bangalore for a Tamil cooking channel who knows Tamil language both read and write. Here's a brief overview of what I'm looking for: Experience in editing cooking videos, particularly Tamil cuisine. Proficiency in latest video editing software and AI tools. Ability to add subtitles in both Tamil and English. Creativity in enhancing video quality and engagement. If this opportunity interests you, I'd love to discuss further details, including compensation and workflow. Feel free to reach out if you have any questions or if you'd like to see samples of our content. Looking forward ...
*PLEASE READ THE GOOGLE DOCK BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the...
I'm seeking a developer who can help me resolve an issue that the google pay button doesn't appear when the allowed auth method is CRYPTOGRAM_3DS. Thank you,
...about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web design packages with confidence, highlighting the value we bring to their business. Closing ...
We are seeking a freelancer to help us recruit testers for a closed testing phase of our mobile app. The app is in its final stages of development, and we need a group of engaged users to participate in a 14-day closed test. Your task will be to find and recruit at least 20 testers who will opt-in and actively use the app during this period. Responsibilities: Identify and recruit a minimum of 20 testers. Ensure testers are engaged and provide feedback over a 14-day period. Monitor the progress and participation of testers. Provide support to testers if they encounter any issues during the testing phase. Collect and organize feedback from testers for our development team. Requirements: Proven experience in recruiting pa...
I'm looking for a skilled React Native developer to assist me in building a Minimum Viable Product (MVP) application. The project involves creating a mobile app that is compatible with both iOS and Android. Ideal skills and experience: - Proficient in React Native, with a proven track record of successful projects - Excellent communication and collaboration skills This project is ideal for a developer who is keen on working on a project from its initial stages and is passionate about creating user-friendly mobile applications.
I am looking for someone that has listened to the Drake vs Kendrick Diss tracks many times. I need someone that is very active with the culture & knows almost everything thats going on in this beef. I need someone that has seen all the memes around the beef. And knows the history of the beef. I'm looking to put together some content around this beef. And I need someone that can guide me. 1. How old are you? 2. Where do you live? 3. Who do you think won the battle and why? 4. If I needed you to defend the loser, could you do so? 5. Tell me something interesting about this beef? 6. What social media platforms are you active on? 7. Did you auto generate this application you sent me, or did ...
Build an AI based tool that has auto voice dubbing and auto voice separation for my videos and Auto dubbing for over foreign 80 languages with close captioning text and an AI-based tool that automatically animates, lights and composes CG characters into a live-action MP4 video scene in AI and Machine learning. Build AI based tool for auto dubbing, close captioning text, Create Professional custom 3D Character animates, lights, and composes CG Robot and Alien and creates custom Voices for the video 3D Robot & Alien characters. You will need to help me create any needed AI access and License accounts. I am seeking a proficient developer to create an AI-based tool that automatically animates, lights and composes CG characters into...
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date ...
I'm looking for someone ...long-term project across maybe even years that will pay you $250-2500 upfront monthly no security payment until you have shown proof of work , depending on the number of clients you bring in and how well you manage them. Ideal candidates should have the following skills: - Mid-level experience in graphic design and video production - Advertising skills is a plus - Proven track record of working in the creative/design industry - Being able to speak and write in fluent english at a minimum You must be a good communicator and able to manage your time efficiently. This is a remote job and you'll be required to provide regular updates on the work you're doing. Please apply...
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
...looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform developm...
I'm looking to hire Key Opinion Consumers/Leaders (KOC/KOL) for the game category. Requirements: - You should have a minimum of 1K followers on your any social medium channel - You must be willing to join our discord channel - Ask 10 friends to join our discord Benefits: - Competitive pay for your services - Opportunity to be a part of a growing community - Flexible working hours - Easy work
I have a website template that needs customization in terms of layout. The main purpose of the site is to showcase my portfolio, the template is ready it needs the to be filled with the correct data. Key Tasks: - Customize layout: I need a professional to make the necessary changes to the layout of my website template, ensuring that it is visually appealing and functional. - Ensure responsiveness: The website should be mobile-responsive, so the freelancer should ensure that the layout changes are consistent across all devices. This project is ideal for a freelance web designer/developer who has a good eye for design and is committed to delivering high-quality work. A portfolio ...
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
I am in need of a professional photographer who specializes in furniture photography. I have an apartment that I plan to host on Airbnb and require detailed, high-resolution photos of various furniture including chairs, tables, and sofas. This is a 1-2 rooms apartment, and it's essential to have photographs of every area, including the kitchen and bathroom. • Proven photography experience, especially in furniture photography • Ability to create attractive shots that capture the details • Experience in editing photos will be advantageous. • Responsibility to care for the furniture while working around it. • Proficient in effectively utilizing lighting to accentuate the aesthetics ...
As a Golang Developer with experience in IT consulting, you'll be a key player in the team working on our new web application. Key Responsibilities: - Developing the web application - Integrating various APIs - Managing the database You should particularly have: - Strong experience in Golang web development - Proficiency with Gin and Beego frameworks - A minimum of 8 years of experience in IT consulting We're looking for someone who can work efficiently both independently and as part of a team. Your commitment and attention to detail are crucial to the success of this project.
I'm looking for a talented individual to virtually stage three rooms of my home. Key Requirements: - The style I'm aiming for is Bohemian. You should be familiar with this design style and be able to source appropriate furniture. - You'll be staging three different rooms so attention to detail is key. Ideal Skills: - Experience with home staging and/or interior design is preferred. - Proficiency with virtual staging software. - Previous work with Bohemian style is a big plus. This project will involve transforming photos of empty rooms into beautifully furnished Bohemian spaces. Your work will play a crucial role in helping me visualize the potential of my home.
...searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solu...
I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?
... with 34 years of growth. We are based in Surrey BC with an operation in Calgary. We recycle textiles from the whole of Western Canada and ship finished product around the world. The recycled textiles are collected from our Big Mouth Donation bins. We are an environmentally green company without the greenwash. Job Description Trans-Continental Textile Recycling Ltd. is looking for a creative graphic designer to design decals for our donation bins placed all around the lower mainland and in Calgary. The ideal candidate must have a minimum of 3 years of experience with either Sign Shop and/or Print Shop and Adobe Illustrator. Knowledge of how to use a Roland TrueVIS VG540 would be highly v...
...interior designer to enhance the layout of my luxury apartment. Need a quick idea for a three-room apartment with a comfortable living room and kitchen. Draw me a minimum of 3 versions of a modern, luxurious layout of rooms that will be logically arranged in the best possible way and well used space to follow modern European design. This plan serves me as an idea for my architect and to meet my needs. That plan is just an idea for the development of a future plan, so that dimensions can be provisional but realistic. Key Requirements: - Reimagine the space to best utilize the area and enhance the luxury feel - Considering the number of r...
...relocation that ensures absolute minimum downtime and zero data loss. Key Tasks: - Transfer the control of my domain () back to registrar 123-reg, so its controlled there. - Then connect the domain () to my current shopify store where we have a webshop built - Transfer the email records from inmotion to shopify/123-reg so the () emails are still functioning - Make sure that the website is fully functional post-transfer - Make sure () email is also fully functioning via Google Workspace Ideal Candidate: - Proven experience in domain and website transfers, especially involving Inmotion, 123-reg, and Shopify - An understanding of potential pitfalls and the ability to troubleshoot problems that...
...website by conducting a full traffic journey analysis using SEMrush. Key Aspects of the Project: - **Understanding User Behavior:** The primary objective of this project is to gain a comprehensive understanding of how users interact with my site. This includes their journey through different pages and their engagement levels. - **Traffic Sources and Volumes:** I aim to analyze the sources of traffic to my website as well as the volume from each source. This will help me identify which channels are most effective in driving traffic. - **Visitor Engagement Metrics:** I'm particularly interested in understanding visitor engagement metrics. This includes the time spent on the site, the number of...
I'm seeking an expert in 3D modeling to create a playful and colorful digital representation of a house from a popular cartoon TV show( Bluey). My priority is for a full house interior layout( furniture optional) , with a close approximation to the on-screen changes throughout show so exact duplicate is not sought. The project is for non commerical purposes(gift for daughter to walk through in vr ) Attached are some ref photos but not complete a internet search will provide imagery or i can provide upon request. (Price is negotiable.) Ideal Candidate: - Experience in creating cartoonish, yet detailed, 3D models - Stylized and colorful artwork portfolio - Previous experience in architectural 3D modeling, specifically houses - Excellent attention to detail ...
I'm seeking a professional logo designer to create a wordmark style logo for my company, P32 Capital. The primary color I'm looking for is blue, as it should convey professionalism. P32 Capital is Real Estate Asset Manager company.
I'm in need of preliminary a detailed and accurate site plan for approximately 20 residential lot development in Jacksonville, Florida. This project requires careful attention to lot sizes and dimensions, as well as adherence to Jacksonville's specific setbacks and zoning regulations. The design should also include necessary road access and infrastructure requirements. The ideal freelancer for this project would have experience in civil engineering or urban planning and have a deep understanding of Jacksonville's local zoning laws. Skills in CAD or other design software are a must. The site location is 3062 Sunnybrook Cr, Jacksonville, Fl 32254 the Lot has an area of 3.47 acres We can split the project in diff...
...search of a full-stack developer to join me in building a scalable, multi-tenant web application. The project requires expertise in Golang and React for back-end and front-end development, respectively. Ideal Candidate: - Proficient in Golang, JavaScript (React) - Skilled in Cassandra, OKTA - Experience with Docker, Kubernetes - Familiarity with Google Cloud Platform -Apply with Github and sample projects The project entails creating a robust, multi-tenant web application that can handle multiple users with varying requirements. It is imperative that the selected developer is competent in ensuring the application's scalability and reliability. If you have previous experience building similar applications, please don't hesitate...
Please use this spreadsheet: I will look over the work from Y, and give feedback before adding more files. You will find the file Y1929 under "files" in this project. Thank you.
...experienced in the Janitorial/Commercial cleaning industry. --- We will pay you per qualified appointment you set. --- We have a high demand for at least 10~18 appointments weekly, and we have multiple areas we can assign you based on your results. So, you can easily earn $750 weekly if you provide quality appointments. --- We are looking for a long-term partnership. We have demand for multiple locations in the US, Canada, and Australia. --- You need to have your own dialer and leads (We have ppl working with us using Google Maps and --- Qualification criteria --- A business with the REAL possibility of becoming our client: NOT pushing appointments, NOT people just looking to compare prices, NOT people happy with their current services. They need to p...
The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) ...
I have a series of videos with basic thumbnails with clickthrough rate 3-5% - public transport topic, metro systems, full journeys. I need help to rework those thumbnails in order to increase the clickthrough rate to 7-10% Please reply with examples you did before
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an...
