Sql remove duplicates from query results jobs

I'm seeking an experienced developer who is proficient at Java Node.js to create a dynamic and interactive betting website. Key points of focus include: - Creation of a user-friendly feature for straightforward odds and results display. No complicated calculations are required, simply a clear presentation of basic odds and stats. - Incorporation of a lively and interactive user interface that allows users to engage and work quickly. Ideal candidates would have extensive experience in similar work, particularly in developing fluid and interactive interfaces. A strong background in Java Node.js API Integaration is mandatory. This project requires a blend of technical skill and creativity to deliver a product that is both functional and user-friendly.

scraping 2750 records from gold-coast-tweed-heads-nsw

...testing results. The report should be clear, well-structured, and easy to understand, as the results will be crucial for my research. I also want the statistical results from the software (tables) and dataset. Ideal Skills and Experience: - Proficient in Structural Equation Modelling (SEM) and SmartPLS: It's essential that you have a deep understanding of SEM and specifically experience using SmartPLS, as this is the software we'll be using to conduct the analysis. - Strong Statistical Background: Sound knowledge of hypothesis testing and moderation analysis is a must. You should be able to interpret the results and translate them into a clear, coherent report. The successful candidate will be someone who can not only deliver accurate an...

...running on version 9.2.0, which is now deprecated. Our goal is to upgrade to version 10.0.0. Project Requirements: Upgrade the existing theme from Vuexy version 9.2.0 to 10.0.0. Ensure that all dependencies are updated and fully compatible with the new version, maintaining the overall functionality and stability of the project. We will provide all necessary files for the upgrade. Support and Collaboration: You will receive comprehensive support throughout the project to facilitate a smooth update process. We are committed to efficient collaboration and hope to establish a long-term relationship with a developer who delivers exemplary results on this project. Future Opportunities: Successful completion of this update opens the potential for further collabora...

I am adding the service of motorbikes lessons to my business so i need a slight variation of my logo. I would like to change the name Driving West Motor School to Riding West Motor School same font. Remove the silhouette of the car and create with a 3d motor bike silhouette using the same style and curved lines riding inwardly on a road but keeping the same L plate.

I'm seeking a skilled PDF editor focusing predominantly on text editing. Ideally, the editor should allow for seamless manipulation of text within the document. Below are the particular requirements: - Text Editing: This is the primary task. Users should be able to add, remove, or modify existing text with ease. This project requires immediate attention, and experience in editing would be beneficial. Please ensure you can commit to a swift completion before bidding.

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

I am quickly seeking a skilled professional to create and simulate load on 5 different profiles using AutoCAD 2020. The load simulation should comply with both DIN 1072 and AASHT...AASHTO H20 standards. - Analyze and explain any observed profile movement, supplementing your explanations with visual depictions. Ideal skills and experience: - Extensive experience in AutoCAD 2020 - Understanding of DIN 1072 and AASHTO H20 load simulation standards - Proficiency in mechanical engineering and structural dynamics - Fluent in report and presentations for clear communication of results I need this project completed as soon as possible, so please only apply if you can deliver within a strict timeline. In your proposal, include relevant project experiences and a proposed schedule to meet my...

I have an Android application that I'd like to enhance with a review feature. - The reviews should be submitted on a third-party platform linked from the app. - Ideally, I'd like to incorporate some form of user authentication before reviews are accepted. I'm open to suggestions on how to best handle the authentication process. The overall goal is to encourage genuine and constructive feedback while preventing spam or irrelevant reviews. I'm looking for a developer with experience in Android app development and implementing user engagement features. It's important that the final solution is user-friendly, secure, and seamlessly integrated with the existing app. Your ability to propose and implement a secure and user-friendly authentication process wil...

...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please provide some exam...

... with the ability to build rapport and establish trust with prospective students. Results-driven mindset with a passion for exceeding targets and driving measurable outcomes. Familiarity with digital marketing tools and platforms is a plus. You Have to Bring 5 Entries for Stock Market course Benefits: Competitive compensation package with performance-based incentives. Flexible working hours and the freedom to work remotely from anywhere. Supportive and collaborative team environment with room for growth and advancement. How to Apply: If you're ready to take on the challenge of driving enrollment in our stock market course and making a positive impact in the lives of aspiring investors, we want to hear from you! Please submit your application detailing your r...

I'm looking for a skilled graphic designer to create a modern and sleek ad for a Facebook campaign. I already have all the necessary assets, and I need it done within 2 hours. Key deliverables and considerations: - Design of Facebook ad creative - Modern and sleek visual style - Ad should be optimized for lead generation - Quick turnaround, due in 2 hours Ideal skills and experience incl...style - Ad should be optimized for lead generation - Quick turnaround, due in 2 hours Ideal skills and experience include: - Proficiency in graphic design tools like Adobe Photoshop or Illustrator - Experience in creating ads for social media platforms, particularly Facebook - Understanding of lead generation tactics in advertising - Ability to work under tight deadlines and deliver high-quality ...

...data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model where users can access more advanced features. This will help monetize the platform and enhance user engagement. User Interface: - Despite the complexity of the system, I'm aiming for a straightforward interface. Users should be able to navigate the website easily without prior training or experience....

I'm seeking a professional freelancer who can meticulously remove text watermarks from various photographs. - Primary Task: Accurate and subtle removal of text watermarks from my photographs, without affecting any area of the images adversely. - Output: Photographs should retain their original quality after the watermark removal. Ideal freelancer must: - Have a proven track record of handling similar projects and using image editing software competently. - Be detail-oriented to ensure that there is no damage to the original image. - Deliver high-quality, original-retaining photographs promptly. Your handling of this task must uphold the integrity of the photographs while removing the watermarks completely.

For this project, I need a proficient AWS lambda specialist. The main function should involve processing well-organized data. The core t...lambda specialist. The main function should involve processing well-organized data. The core tasks and qualifications of the project are as follows: Tasks: - Implement an AWS lambda function to process structured data - Fetch the necessary data from an S3 source Required Experience and Skills: - Extensive understanding of AWS Lambda functions - Proven experience in processing structured data - Experience in sourcing data from an S3 Database is highly beneficial Your ability to understand the unique requirements of the project and deliver efficient results will set you apart. Let's collaborate to make this project a success. ...

I'm in need of a proficient researcher to help me with a project focused on solving the maximally diverse grouping problem. This project is specifically focused on a research-based approach and will require the selected candidate to assist with the implementation o...on optimal ways to maximize diversity within a group i am unable to getting the fitness values on my worked code please help me to get the desired values that it i need it urgently Ideal Candidate: - Proven experience in research and implementing hyper-heuristics - Strong understanding of diversity maximization and grouping problems - Ability to work independently and deliver high-quality results within the specified timeline - who knows how to debug the code - Excellent communication skills to discuss concept...

I'm in need of a proficient researcher to help me with a project focused on solving the maximally diverse grouping problem. This project is specifically focused on a research-based approach and will require the selected candidate to assist with the implementation of hyper-heuristics. Key Responsi...and Repair Operation' heuristics - Calculate the Fitness values and need to compare with the SGGA , VNS , IMS - Providing expertise on optimal ways to maximize diversity within a group Ideal Candidate: - Proven experience in research and implementing hyper-heuristics - Strong understanding of diversity maximization and grouping problems - Ability to work independently and deliver high-quality results within the specified timeline - Excellent communication skills to discuss co...

...1. Instagram, Facebook, TikTok, and Google shop: I have already created the catalogue for my Facebook and IG shop, but it is in the review stage; something went wrong. I need a setup in which if I add or remove products from the Shopify store, it should sync with all the other shops. Check my store shipping and cart page settings: 2. Check if the shipping settings are correct on my store. Customize shipping and cart pages if necessary to make them look more professional. 3. Instagram, Facebook, TikTok, and Google ads: I don’t have actual products for ads; we will need to check ads from others and edit them to create our own content. Please suggest a budget for my ads. I have already tried to create a Facebook business portfolio, a Facebook and Instagram pag...

...training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certifications or qualifications in mind, a degree in Computer Science or a related field is preferred. This is an exciting opportunity to join a dynamic team and contribute to the development of our software. If you have the skills and experience, we're looking for, we'd love to hear from you. Required: 10 candid...

...effective. Key Responsibilities: - Analyze user feedback: You'll be responsible for analyzing the user feedback and finding out the areas where our communication with customers can be better. - Suggest and Implement Changes: After analyzing the feedback, you will need to come up with suggestions on how we can improve and then implement these changes effectively. - Monitor the Results: It will be your duty to monitor the results of the changes made and assess how they have affected the user experience and customer communication. Skills & Experience: - Proven experience in User Experience: A background in improving user experience is a must for this role. - Strong Analytical Skills: You should be able to analyze data and feedback effectively to draw out useful ins...

...to create a Serp Tracking system for my Perfex CRM tool. Key features include: - **Rank Tracking:** The completed system should be able to track keyword ranks efficiently. - **Keyword Rank Tracking:** Instead of tracking URL or competitor ranks, the focus should be on keyword ranking. - **Detailed Tracking:** The system should be capable of tracking and delivering the top 500 search engine results for each keyword. Ideal candidates will have previous experience building Serp Tracking systems particularly for Perfex CRM. Proficiency in keyword rank tracking is a must for this job. and -- I want to develop a Serp Tracking system for the Perfex CRM system. The customer's website is available in the customer data. I need a system where I can enter various keywords ac...

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

...analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirements: Proven expertise in ...

I'm looking for a skilled Virtual Assistant based in Malaysia to help me with sales activities, it's 2hours task daily. Commission based. Your prima...physical store setting, would be a plus. You need to be proactive, excellent at communication and a quick learner. Your tasks will involve: - Conducting sales activities - Reporting on sales activities and results -being on time. As a Virtual Assistant, you'll mostly be working remotely. However, I may need you to visit the physical store occasionally. so please consider your location in Malaysia and your ability to travel as needed. If you have a sales-oriented mindset, are comfortable with cold calling and follow-up emails, and have experience in a sales role, I'd love to hear from you. Prior experi...

I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.

As an online service provider, I'm seeking a skilled salesperson with a particular focus on B2B sales. The objective is to promote and sell our services to potential clients. Key Responsibilities: - Conduct B2B sales for our services - Develop and maintain constructive relationships with client...of our services to prospective clients Preferred Channels: - Email: Proficiency in composing and sending engaging emails to potential clients. - LinkedIn: Capability to effectively utilize LinkedIn for outreach and connection building. The ideal candidate must have a deep understanding of B2B sales, be results-driven, and possess a knack for building and maintaining strong client relationships. Experience in selling services is highly valued. If you meet these criteria, I'd lo...

I'm looking for a skilled statistician with experience in R and survival analysis. Key Requirements: - Utilize Kaplan-Meier estimator for survival probability estimation. - Implement the analysis within a public health context. Ideal Candidate: - Proficient in R software and survival analysis techniques. - Solid understanding of public health, especially survival analysis in this domain. ...survival analysis. Key Requirements: - Utilize Kaplan-Meier estimator for survival probability estimation. - Implement the analysis within a public health context. Ideal Candidate: - Proficient in R software and survival analysis techniques. - Solid understanding of public health, especially survival analysis in this domain. - Strong statistical background ensuring accurate and insightful ...

I am searching for an accomplished electrical engineer and coder who possesses advanced technical abilities in circuit design, analysis, and programming microcontrollers, namely with Raspberry Pi. These skills are necessary for the fruitful completion of the project. Key Responsibilities: - Design creativeness is a must as I place an emphasis on compact-sized micro-circuits. - Robust...diagnosing and troubleshooting electrical systems when the need arises. The successful freelancer will ideally have substantial experience in Python as this is the preferred programming tool for this project. The end goal is to develop a smoothly functioning system based on the defined parameters. With your specialized skills and my unique ideas, collaborating on this venture could yield exceptional re...

I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantit...job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality resu...

conversion modeling / predictive analytics. The whole department is transitioning to DataBricks. I need help with creating conversion models using pyspark. Compare the results to last year and what could have been a better approach.

I'm looking for a diligent freelancer who can help with entering text data from handwritten documents into a digital format. Requirements: - Entering text data from handwritten documents - Ensuring general accuracy (minor errors are acceptable) - Organizing the data in a clear and coherent manner Ideal Skills: - Proficiency in data entry - Attention to detail - Patience and perseverance - Basic understanding of the English language The task requires someone who is meticulous and can maintain a good level of accuracy throughout the process. If you have experience with data entry and can ensure timelines are met, I'd love to hear from you.

...website's search engine rankings and drive increased traffic. KEY REQUIREMENTS: - Increase Website Traffic: My main goal is to attract more local customers to my landscaping services website. The successful freelancer will be able to implement strategies that drive relevant traffic to my site. - Improve Search Engine Rankings: I'm also looking to improve my site's positioning in search engine results. I need someone who can perform a detailed SEO audit, identify areas for improvement, and implement effective strategies to boost my rankings. - Understanding of Local SEO: As my target audience is local, it's crucial that the freelancer understands the nuances of local SEO and can tailor their approach to reach this specific demographic. - Content Creation: ...

I need a Word file created from the content I will provide. The content will be used for a legal documentation/report. Key Requirements: - Type the provided content into a Word file - Ensure accuracy and appropriate formatting - Comprehension of legal terminologies and conventions is preferred, though not mandatory Ideal Skills: - Fast and accurate typing - Experience with Word processing - Understanding of legal terminology (preferred) Please note, the content will be provided in raw form and will need to be transformed into a cohesive, well-structured document. If you have experience in legal document creation, it would be a huge plus.

I'm looking for a skilled SEO professional who can help me boost myrealtypage-based website's performance. Key Points: - I aim to increase the website traffic, improve search engine rankings, and generate more leads - ultimately aiming for a broader audience reach and higher conversion rates. - My primary target audience includes home buyers and mortgage applican...implementation on This feature is crucial for enhancing user experience and client interaction. I'm looking for a professional with proven experience in SEO for real estate websites, understanding of the home buyer and mortgage applicant market, and the ability to quickly and effectively implement a Facebook Messenger chatbot. If you possess these skills and can deliver timely results, please reach out.

As the project manager, I am seeking an expert who can assist in conducting a Computational Fluid Dynamics (CFD) analysis for an underwater equipment design. The primary goal of the project is to improve equipment efficiency. The successful individual must therefore be profi...improvement to enhance efficiency - Advising on appropriate design modifications A background in fluid dynamics coupled with an understanding of underwater equipment will be necessary for this task. Additionally, the potential to perceive potential issues before manufacturing will be a significant asset. Please ensure you've ample experience in the implementation of design changes based on CFD analysis results. With your expert assistance, I am looking forward to making equipment with enhanced operatio...

...be responsible for ensuring the website is running smoothly, keeping the design up-to-date, and overseeing its overall functionality. - **Content Creation:** As my website manager, you'll be tasked with creating engaging and SEO-optimized content for the site. - **SEO Optimization:** You'll need to possess a strong understanding of SEO practices to ensure the website ranks well in search engine results. Marketing Channels: - **Social Media:** Your role will include managing the social media profiles of my E-commerce store. You'll be expected to create engaging content, respond to customer queries, and grow the social media following. - **Search Engine Advertising:** The ideal candidate should have experience in managing advertising campaigns on search engines, par...

This project will require an in-depth study of 25 large and specific clients within the FMCG sector. Attention will be particularly given to those in the food and beverage, household products, and personal care products segments. Your tasks will involve: - Detailed web digging from platforms like LinkedIn, internal client sites, and recent publications to collect and analyze data. - Pinpointing company trends and identifying industry jargon currently in use by these particular clients. - Compiling this data into succinct, comprehensive one-page reports per client. The ideal freelancer for this job should have: - Solid business acumen and effective online research skills. - Research skills with data scrapping and leveraging LLMs to pull data effectively - Robust summary and repo...

I need a skilled Photoshop expert to edit 20-30 pieces of children's artwork for a photo book. Each artwork req...requires attention to detail in various alterations. Not all images require all elements of the below but overall your role will include: - Color correction in CYMK - Background removal - childs name removal - Re-sizing and straightening image - placement of artwork onto a solid colour background/creation of border - Generative fill to expand the background on selected images - Basic retouching to remove paper wrinkles on some images The final edited works need to be high-resolution (300 dpi). Experience in children's artwork corrections or similar projects will be of advantage. Please bid with a realistic timeline as well as your portfolio showing previo...

I am looking for an exceptional freelancer who is proficient in mapping...an exceptional freelancer who is proficient in mapping Amazon USA listings from other sellers. This project requires someone who can efficiently remove any other sellers' Amazon USA listings. Key Requirements: - You will need to perform listing mapping specifically for product titles, descriptions, and images. - Experience with Amazon API is a must for this project. To apply, you should: - Highlight your relevant experience - Provide proof of past successes. Please note: Generic applications will not be considered. Only apply if you have direct experience with Amazon USA listing mapping. This project is highly specialized and demands someone with the right experience and skills. I look forwar...

...clients. An understanding of the limousine industry would be a significant plus. A proactive and results-driven approach will be essential in order to meet our business growth objectives. Key responsibilities for this project will include: - Developing a strategic approach to reaching out to businesses in a targeted manner - Marketing our services effectively to showcase the value proposition of our limousine service - Bringing in new clients within the corporate, wedding, and airport transportation segments - Establishing a pipeline of potential clients for future business opportunities If you are confident in your ability to drive business growth for a limousine service, I would like to hear from you. Please include in your proposal any relevant experience and success...

I'm seeking a proficient Python data analyst who can unlock interesting trend patterns within a dataset using machine learning models. Your expertise will be instrumental in making sense of the underlying trends that the raw data contains. The main responsibilities wi... Someone with experience in data analysis using Python, as well as a comprehensive understanding of machine learning models, would be most suitable for this project. Flexibility in working with different data types will also be a paramount attribute. Please include instances where you have successfully identified trend patterns from datasets in your bid. •Focus: –Key data insight from analysis –Post analysis hypothesis (if any) –Data model used and metrics –Results t...

I'm seeking a proficient Python data analyst who can unlock interesting trend patterns within a dataset using machine learning models. Your expertise will be instrumental in making sense of the underlying trends that the raw data contains. The main responsibilities wi... Someone with experience in data analysis using Python, as well as a comprehensive understanding of machine learning models, would be most suitable for this project. Flexibility in working with different data types will also be a paramount attribute. Please include instances where you have successfully identified trend patterns from datasets in your bid. •Focus: –Key data insight from analysis –Post analysis hypothesis (if any) –Data model used and metrics –Results t...

I'm looking for a talented photo editor to remove a stomach bulge from one of my pictures. The goal is to make the area appear slimmer without affecting the natural skin texture. Key Responsibilities: - Use Photoshop or a similar photo editing tool to trim the stomach area. - Keep the skin texture as natural as possible. - Deliver a final image that looks professionally edited and natural. The ideal freelancer for this job would have: - Proficiency in photo editing software, preferably Photoshop. - Experience with body shape manipulation and slimming on photos. - Excellent attention to detail. - The ability to adhere to a natural skin texture while editing. I'm not looking for additional enhancements beyond the stomach trimming, but if you believe there&...

I have a hosting on Bluehost that is infected with malware, on this hosting I have around more than 50 websites, but I want to focus on 3 specific websites, I want these sites to be cleaned and migrated to a VPS that I have with another provider , we look for efficient methods that guarantee 100% security that no malware will be transferred to the vps, we seek to be aware of the process and know the methodologies applied, therefore we hope that these 3 websites are completely free of malware at the time they arrive at the new VPS, both the cleaning and the migration is what we are looking for the job.

...customized bidding module. Key Features: - Inventory, Financial, Human Resources Management: The system should include these traditional ERP features. - Bidding Module: This module is crucial. I require an intuitive, user-friendly system for creating and managing bid requests. The system should display bid status and progress accurately and in real-time. Moreover, automatic notifications of bid results are essential for the smooth functioning of the module. Design Preferences: - The design of the bidding module is paramount. It should be clean, minimalistic, and modern. I'd also like some customization options available for the design to suit our company's branding and aesthetics. Ideal Skills: - Proven experience in developing complex ERP systems. - Prior experienc...

...as this will primarily be utilized for research purposes. The results should be reliable and consistent. - Image Type: The CT images to be segmented are specific to the brain. Therefore, experience with this type of image segmentation is highly desirable. Ideal Skills and Experience: - Proficiency in medical image segmentation, particularly with CT images and the brain. - Strong background in unsupervised machine learning techniques, with a focus on fuzzy-based methodologies. - Proven experience in delivering moderately accurate results for research purposes. - Ability to ensure the segmentation is in line with medical standards and practices. If you think you have the expertise required for this project, I'd love to hear from you. Please share relevant expe...

...user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service where it is possible to obtain the user's total coins and record of consecutive days marked; Screen 1: - When opening the app, if there is a project started, jump to screen 2. If not, list projects. - The user must choose a project from the list on the first screen to continue and start. - Get list data via http from

...it. 4. Style this page to match the attached design. 5. Menu: the design does not have a menu, but we want the current menu to stay in place and be sticky. Replace the menu items to link to each section of the site. 6. We want some scrolling animations through out the page. These are built into Avada, just apply paralax or scrolling animations where it looks cool. > Here are examples of the site from previous year's and the type of animations they are expecting: 7. For the 'Project Highlights' section, each image should open a modal with details on the project. These details are found in the 'Project ' document, with additional images in the ''Project Photos" folder 8. All images will be provided in

I'm looking for a skilled photo editor to remove unwanted objects from the background of 8 photos. The objects include vehicles, power lines, partial buildings, and roads. The ideal freelancer will have expertise in photo editing and manipulation, with a sharp eye for detail and a strong portfolio that demonstrates previous work in similar projects. Key requirements: - Removing vehicles, power lines, partial buildings, and roads from the background of 8 photos. - Ensuring the new background looks like natural scenery. Please submit your past work for review.

...considerably optimize my website's performance as well as improve its visibility on Google, I'm actively seeking the expertise of a seasoned SEO specialist. I need assistance with on-page and off-page optimization, keyword research, and improving my site's Google ranking. My goals are to boost organic traffic, rank higher for specific keywords and overall enhance my website's visibility on search engine results. Previous SEO activities have been conducted on the website, therefore, a familiarity with analyzing past SEO efforts would be beneficial in managing, improving and, where necessary, changing these strategies. Ideal skills include: - Proficiency in SEO tools and software - Solid understanding of performance marketing, conversion, and online customer ac...