Sql select count of rows with same values in one column jobs
...provided with - - Niche of the site - A brief description of the niche - 6 Main Categories of the Niche site we'll be building (You can suggest improvements) These are for brand new websites - so your research should encompass the same. We want the following - - 500 Keywords Per Category Total - 3000 Keywords We want low competition, high to mid traffic keywords. Cluster where needed, we don't want keyword repetition at all. We want to avoid keyword cannibalization at any cost. You can use Ubersuggest, Ahrefs or Semrush Keyword Magic. We will require a detailed colour spreadhseet containing the search terms and data in easy to understand format, each column should list the keyword, searches per month, cost per click. P...
I require a talented web developer to fine-tune my unfinished WordPress site. Key Areas of Improvement: - Design/Layout: Customizing the theme and enhancing visual aesthetics to create a more appealing and user-friendly interface. - Functionality/Features: Troubleshooting and improving certain plugins/add-ons, as well as refining forms and interactive elements for seamless functionality. - Content/SEO: Optimizing the site’s content and SEO parameters for better visibility and reach. Ideal Skills: - Proficiency in WordPress with a strong focus on theme customization. - Extensive experience with WordPress plugins and interactive elements. - Strong understanding of SEO principles and content optimization. - A keen eye for design and visual elements.
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? Within a month
...heritage while promoting sustainability, empowerment, and social justice. The logo will be the cornerstone of our brand identity, appearing on product packaging, marketing materials, and digital platforms. This is your opportunity to bring a meaningful vision to life, merging tradition, strength, and modern elegance. Design Guidelines: Core Elements: Replace the large "WPB" concept with two gold war paint strikes to symbolize strength and protection. Include a tagline: Empowered and Proud beneath the logo. Incorporate arrowhead symbols on each side of the logo, but only one arrowhead per side, designed to fill the space proportionally. A subtle teepee-inspired "A" can be explored to align with Indigenous artistry. Inspiration: F...
I'm looking for a freelancer who can help me articulate my business and industry. We need a concise and engaging description that covers the following: - A clear articulation of what our business is about, including our core values, purpose, and strategy. - A brief overview of the industry we operate in. Ideally, you would have experience in business writing and understand the nuances of the technology, healthcare, and retail industries.
I'm seeking a professional who already have a prof...Creation: Help refine our initial game concept into a compelling and engaging play-to-earn game. - Technical Development: Oversee the technical development of the game and its native cryptocurrency. - Marketing Strategy: Devise an effective marketing strategy to promote the game pre-launch and throughout its lifecycle. - Deposit, withdraw and rankings features. Ideal Skills and Experience: - Proven experience in game development, particularly in the play-to-earn sector. - Deep understanding of the Solana blockchain and its capabilities. - Strong background in cryptocurrency development. - Excellent marketing skills, with a proven track record of successful game launches. - Innovative...
I'm in need of a dynamic and energetic video editor for my YouTube channel. Channel will be focusing on reviews, advice, business and behind the scenes. Looking for someone I can slowly grow with! @AndreiRoman Key Responsibilities: - Edit videos to reflect a dynamic, fast-paced style - Incorporate text overlays and annotations at relevant points - Select and integrate appropriate background music and sound effects - Utilize transitions and visual effects to maintain viewer engagement The ideal candidate would be a skilled video editor with a good understanding of YouTube's format and viewer expectations. Experience with product review and unboxing content is a plus. A keen sense for energetic pacing and the ability to keep the ...
...mechanics in the tool. The designs must be modular and functional for layering different assets like clothing and accessories and will feature customizable RGB color values for skin, hair, eyes, clothing, and accessories. The characters should allow users to adjust these features using RGB sliders (to customize the color directly, not pre-designed options). Additionally, shading and highlights must be incorporated in a way that works with RGB color customization, using separate layers (details in pm). --- Style Preferences: Clean, anime Japanese or manwha 2D art style. Vector or flat-shaded design (no heavy shading or gradients). RGB-friendly to allow skin, hair, eyes, and clothing to be customizable. Modular and adaptable for layering. --- Skil...
I need an AWS AI Expert with experience in creating chabots connected to PDF, Words, Excels... Also they need to be able to query data from SQL Databases. You need to integrate this in an existing Flask App. I am Python developer and will be supervising your job, just need assistance with this AI service.
...the premium nature of the product. Key Aspects of the Project: - Design a full package, front and back, of a product pouch. - Improve upon my current mock-up. - Incorporate the nutritional panel on the back of the pouch, along with a product description. - Create a design using a black, white, and gold color palette. Elements to Highlight: - The front of the pouch should prominently feature our brand name and logo, as well as the product benefits. Ideal Skills & Experience: - Strong background in packaging design, particularly for premium products. - Experience with minimalist, clean, and elegant design aesthetics. - Proficiency in creating visually appealing and informative nutritional panels and product descriptions...
I'm in the process of starting a cleaning service business and need a WordPress expert to help me design a professional and corporate styled website. Key Features: - Custom WordPress Design: I want a modern, sleek, and professional looking site that reflects the corporate nature of my business. - Client Portal: This portal should include functionalities such as appointment booking, invoice management, and service requests. - Employee Portal: Although I have not fully decided on the functionalities for this portal, it will likely include aspects of job scheduling and timesheet management. Ideally, the freelancer for this project should have extensive experience with WordPress and WordPress theme customization. A portfolio of similar corporate...
i need help with an exam for Microsoft server tecnologies(MST), the exam is 5 hours, its 7 questions, might need to be done trough only desk to remote control my pc, the date for the exam is 05.01.2025. lowest price bider wil be choosen, the person need to have experience with microsoft server. Installation and Configuration: Understanding Windows Server deployment, updates, and patching. Active Directory (AD): Managing domains, forests, trusts, Group Policy (GPO), and user/group permissions. DNS, DHCP, and Networking: Configuring and troubleshooting network services like DNS, DHCP, IP addressing, and subnets. 2. Virtualization and Cloud Hyper-V: Setting up virtual machines, virtual networks, and storage in a Hyper-V environment. Azure Services (if relevant): Knowledge...
I'm looking for a freelancer who can help me articulate my business and industry. We need a concise and engaging description that covers the following: - A clear articulation of what our business is about, including our core values, purpose, and strategy. - A brief overview of the industry we operate in. Ideally, you would have experience in business writing and understand the nuances of the technology, healthcare, and retail industries.
Project Description: We are Knallfrosch, a company specializing in unforgettable event experiences for children and families. Our goal is to refresh our logo with a modern and captivating design that reflects our creativity, playfulness, and professionalism. We are seeking a talented designer to help us create a new logo that: Offers a fresh and modern look. Can be inspired by our current logo, but new creative approaches are also welcome. Captures the essence of our brand—vibrant, joyful, and family-friendly. Key Details: Color Palette: Feel free to experiment, but designs should maintain a warm, inviting tone. Typography: Should be clean and easily readable across various platforms. Style: Versatile enough to work on digital media, print materials, and mercha...
I'm in need of a professional who can assist with registering both my trademark name and logo in the UK. This is crucial as my product, which falls under the 'pharmaceutical , medical devices , cosmetics , food supplements' category, is sold internationally. Key Responsibilities: - Assist in the registration of my trademark name and logo in the UK. - Ensure the trademark registration process is compliant with international standards. Ideal Skills: - Proven experience in trademark registration, particularly in the UK. - Knowledge of international trademark laws. - Strong attention to detail to ensure all aspects of the trademark are correctly registered.
...might look like in the future, particularly if humans were to colonize it. Key Focus Areas: - Housing: Visualizing various living habitats and their evolution. - Transportation Systems: Illustrating how we might traverse the Martian landscape. - Public Spaces: Conceptualizing communal areas on a colonized Mars. - Future Technologies: Integrating advanced tech into the animation. Depicing how humans live and thrive on the planet Style: The animation should have a 'futuristic' tone. It needs to push the boundaries of current day visuals, showing a Mars that is not only colonized but thriving. Ideal Skills: - Proficient in 3D animation software. - Experience with creating educational content. - Ability to conceptualize and visualize futuristic scen...
...presentation is primarily a business pitch, so it needs to convey our objectives, strategies, and potential in a compelling manner. Key Requirements: - Experience in designing business presentations - Proficient in creating and integrating graphs and charts, images and infographics into a presentation - Able to edit and improve the content of the presentation to enhance its effectiveness The ideal candidate will have a strong understanding of business concepts, be able to edit and design my presentation to be attractive and engaging for our new CEO, and ultimately help us win the support we need for our business initiatives. Please provide examples of previous work that aligns with this project. MORE DETAILS and context I lead a cybe...
...primary goal of this deck is to attract potential sponsors of an online social column that I hope to publish from my coverage of local events in my community. It will have elements of a traditional society column but will also highlight important causes. I hope to attracted multi-tiered sponsorship from local businesses, mostly geared toward higher-income earners. I have attached a draft business plan but am still trying to figure out what I'm seeking, in terms of sponsorship. I'm thinking in the neighbourhood of $60-$80K. Key Requirements: - Deep understanding of the digital media landscape - Proven experience in creating investor pitch decks - Strong storytelling and presentation ski...
I am in need of a skilled backend developer to create an API that will interact with a SQL database (MySQL or PostgreSQL). The API should be capable of performing various operations such as: - CRUD (Create, Read, Update, Delete) operations on records - Executing complex data queries and generating reports - Handling user authentication and session management The ideal freelancer for this project should have extensive experience in API development and working with SQL databases. Understanding of user authentication systems and session management is also crucial.
I'm looking for a photo editor who can merge two images for me. The first image is of my grandpa and cousin with my cousin's first deer. The second image is of my great grandpa. I want the final image to depict my great grandpa as a spirit overlooking his son and grandson. The mood of the image should convey a happy memory. Ideal Skills: - Photo editing - Experience with merging images - Able to create a spirit-like figure Specific Requirements: - The stylistic approach should make my great grandpa look like a spirit. - The final image should be in black and white, almost faded into the backdrop.
I'm looking for a video editor who can transform my real estate footage into a cinematic property showcase. The final product should be engaging, with smooth transitions, beautiful visuals, and a fitting musical score that enhances the viewing experience. Key Requirements: - Expertise in editing real estate videos - Proficiency in creating cinematic style video with music - Ability to select suitable, engaging royalty-free music Must include samples of REAL ESTATE VIDEO work in your application.
...Systems. Your content should cover key topics such as Real-time operating systems (RTOS), advanced microcontroller programming, and embedded system security. The Educational Engineering Academy (EEA) is seeking experienced instructors to create high-quality video tutorials across a range of technical topics. We are hiring for multiple courses, covering Embedded Systems, Data Analytics, ARM Programming, IoT, Automotive Technologies, and Linux Administration. Overview: Payment is based on the number of final video hours delivered. Applicants must submit a sample video (Google Drive link or file upload) explaining a mid-to-advanced embedded systems topic to demonstrate teaching and recording ability. Flexible schedule – work at your own pace while adhering to the pr...
...an experienced Android developer to build a simple One-Page Kotlin-based app that displays multiple cards in a list. Each card will have specific details. Key Features: Page 1: Display multiple cards, each containing: User Name User Expertise Status (Running/Stopped) Start and Stop buttons for each card. Each Start button will be associated with a unique API URL. When the Start button is clicked: The corresponding API will be called every 5 seconds. The app should continue calling the API every 5 seconds, even if the app is in the background, until the Stop button is clicked. Stop button: Stops the API calls. Multiple APIs can run simultaneously. Technical Requirements: Kotlin for Android development. RecyclerView to display the list of cards. Corou...
I'm a student working on a project utilizing LightweightCharts by TradingView. I need a developer to assist me in adding bar pattern tool similar to the one in TradingView. Key Features Needed: - Users can select a range of bars (candlesticks) in two clicks. - The first click selects the start of the range. - The second click selects the end of the range and draws a pattern over the selection. - The pattern should be visualized over the selected bars and be draggable or editable. Requirements: - The tool should interact with other chart features. - The most crucial aspect of this interaction is the ability for patterns to be draggable and scalable. What I've Accomplished So Far: - I've successfully inte...
I need to create a simple one product shopify shop using this as inspiring: slideshow, 3 differents offers depending on quantity, reviews count, etc. It need to be adapted to mobile as 90% of visits will come from there Samples 1: Sample 2:
I'm looking for a freelancer with experience in Leadpages and web design to revamp our thank you page into a fun and vibrant style. The page needs to accommodate an embedded Product Demo video, and showcase three purchasing options in a side by side column layout. Key requirements: - Proficient in Leadpages - Web design experience - Creative with a knack for fun and vibrant designs Please provide examples of similar projects you've completed.
...skilled Python developer with experience in Raspberry Pi, I2C communication, and MLX90640 thermal camera modules. This project involves developing a Python library to enable the continuous and parallel operation of four thermal cameras, capturing data at a minimum frequency of 8Hz per camera, without the use of a multiplexer. Key Requirements: 1. Python Library Development: - Create a custom Python library for MLX90640 thermal camera modules. - Enable continuous data capture for all pixels (24x32 resolution) for four cameras, saving the data into CSV files. 2. Communication Setup: - Establish custom I2C buses for each camera using predefined Raspberry Pi pins (rearrangements possible but limited). - If a more optimal way of...
Its basically a chess game library, and its in worse condition, So this needs to be redesigned as per proper clean-code principles, so that it becomes easy to extend
the landing page should be world class, it should have a prompt for our upcoming Android app to be launched soon and a login button for patients
...website for our personal care brand. The ideal candidate will understand the aesthetics and functionality needed for an online personal care business. Key responsibilities include: 1. Basic Website Design: Create a visually appealing and intuitive design aligned with the brand’s identity. 2. Essential Pages: 2.1 Home Page: Engaging and informative, with a clear call-to-action. 2.2 Product Page: A showcase of our product offerings with clear descriptions and images. 2.3 About Us: A page telling the story of our brand, values, and mission. 2.4 Contact Us: Simple form or contact details for customer inquiries. Pages: Additional pages may be discussed and added after initial discussions (e.g., blog, FAQ, etc.). Design: Ensure the w...
Logo Design for a Luxury Skincare Brand: Name Of Brand: Veluve Slogan: Eternal Elegance Overview: Veluve is a premium luxury skincare brand that embodies elegance, sophistication, and natural beauty. We are seeking a logo that reflects our brand identity while maintaining a clean, timeless look. Design Requirements: Color Theme: The primary theme should revolve around gold, silver, or earth tones (e.g., soft browns, greens, or taupes). Designers can choose one primary theme or blend two of the three (e.g., gold and earth tones, or silver and gold) for a harmonious and luxurious palette. Artistic Focus: The “V” in Veluve should be a focal point, with artistic detail that makes it stand out. Think elegant, intricate, yet not overly compl...
Development Scope: 3 Projects 1. Advertising Platform Develop an advertising platform equipped with multiple simple 2D games that end within 30 seconds. Budget: $350 2. Cosmetics Shopping Mall Solution Only developers with pre-existing source code for a cosmetics shopping mall solution may apply. Budget: $350 3. Translation Platform Service Develop a translation platform service delivered as a plugin, API, or widget. Budget: $350 Participation Requirements: 1. Minimum of 5 years of development experience. Only teams with extensive experience should apply. 2. Teams must be capable of handling development, design, screen planning, and UI/UX. 3. As the client does not speak English, only developers comfortable using t...
...resourceful, and skilled at setting up social media profiles, this could be the perfect project for you! What We Need: Setup of Social Media Accounts: Create and optimize profiles on platforms like LinkedIn, Facebook, and Instagram. Simple Branding: Ensure profiles look professional and align with our company’s values. Basic Guidance: Provide tips or a brief plan for how to engage and grow our audience over time. Who You Are: Experienced in social media setup and optimization. Comfortable working with a small budget while delivering quality results. A creative thinker with a knack for designing professional-looking profiles. Budget: This is a starter project with a budget of $200 or less, so it’s ideal for someone l...
...additional pages and making minor enhancements to improve the website's appeal and functionality. Scope of Work: 1. New Pages to Be Designed:** - Services Page: Outline the services we offer. - Industries Page: Showcase the industries we cater to. - Vision, Mission, and Policies Page: Display our company’s core values, mission statement, and vision. 2. Enhancements: - Add animations or visual elements to make the website more engaging. - Ensure design consistency across all pages. - Make minor adjustments or changes to align with the overall branding. Key Requirements: - Strong portfolio showcasing relevant website design experience. - Familiarity with clean, professional, and minimalistic designs. - Ab...
...and Sintra. - Select and incorporate 2-3 upbeat, family-friendly songs. - Combine clips and photos with fast cuts and dynamic transitions. - Use effects like slow-motion and color grading to enhance the visuals. - Add text labels for locations (e.g., "Albufeira - Algarve Coast"). - Focus on candid moments and natural family interactions. - Synchronize transitions and clips to the music’s rhythm. Final Deliverables: - A joyful 4-6 minute video highlighting the best moments of our summer vacation. - Rendered in 4K resolution, MP4 file. - Subtle sound effects (e.g., waves, birds) for ambiance. Ideal Skills: - Proficiency in video editing software. - Experience with color grading and visual effects. - Ability to create a narrative ...
I have a simple CSS modification task that should only take around an hour. I need a freelancer who can help me adjust the layout and positioning of the main content on my site. Specific tasks will include: - Adjusting column sizes - Repositioning elements Ideal candidates will have: - Proficiency in CSS - Experience with layout and positioning modifications - Ability to work efficiently to meet the 1-hour time frame
...seeking a talented 3D artist to help visualize a 4-floor building, with a focus on the exterior and the first two floors. The first floor is a business space designed with a luxurious and upscale interior style. Key Requirements: 1. Create a 3D visualization of the 1st floor that's suitable for various business purposes, featuring a modern and appealing entrance door. 2. Design the 2nd floor 3D visualization, which should include a detailed furniture layout, clever lighting design, and stylish wall and floor finishes. 3. Develop a 3D visualization of the Penthouse on the 4th floor, with less emphasis on detail but still maintaining the overall modern aesthetic of the building. Skills and Experience: - Proven experience in 3D modeli...
As per our agreement we will focus on the UI of the work deliverables we discussed
...create a detailed 3D architecture model of a residential building in Revit. The project involves: - Adding Rebars in slab, one beam and one column - Incorporating various detailing, objects and features such as a parapet, boundary wall, lawn, roads, and furniture The ideal candidate should have a strong background in architecture and engineering, with extensive experience in using Revit and Navisworks. You will need to perform a professional 4D simulation in Navisworks. Additionally, I would need you to provide: - Rendered Images - A walkthrough/flythrough animation that includes enough detailing such as furniture and other necessary objects for the project. Your bid will be assessed on your portfolio showcasing...
I am in need of a professional who can help me repair a corrupted SQL Server 2005 .bak file. The file is not restoring properly and I have received an error message while attempting to do so. The specific error message I received was "Unexpected end of file". Ideal skills and experience for this job include: - Extensive knowledge and experience with SQL Server 2005 - Proven track record of repairing .bak files - Ability to troubleshoot and resolve file restoration issues - Excellent understanding of SQL Server error messages and their solutions. Your expertise in this matter would be greatly appreciated.
I'm in need of a game developer to create a Sudoku game (9x9 grid) for my website. The game should cater to varying difficulty levels: Easy, Medium, Hard, and Extreme. Key features: - A table (without borders) below the puzzle displaying numbers 1 to 9, with options for undo, hint, and solution. - A timer positioned above the puzzle. - An option to select a difficulty level and subsequently generate and print multiple Sudoku puzzles onto an 8.5x11 inch PDF file. - Compatibility with both desktop and mobile browsers. - A modern design interface. - Daily Sudoku challenges. - A leaderboard to track player scores. Ideal skills and experience for this project include: - Proficiency in game development, particularly web-based games. - Experience ...
I'm in need of a Microsoft Power App that connects to an Excel sheet for creating data entries across 6 columns. The data entries will be a mix of text and numeric values. Key Features: - Mixed data types: The app should allow for both text and numeric entries. - Some predefined options: Certain columns will require dropdowns or fixed options for text entries, while others will be open for free text. - No numeric validation: There are no specific rules or range limits for the numeric entries. Ideal candidate should have: - Proven experience in developing Microsoft Power Apps. - Strong skills in Excel, particularly in setting up sheets for data connection. - Ability to create user-friendly interfaces with dropdowns an...
...website capable of displaying product images from a database and asking potential customers a series of questions to generate a quote for painting services. Key Features: - Display of product images - Interactive customer questionnaire covering service preferences and contact information Design: - I already have a specific design for the website Ideal Skills: - Web Development - Database Management - User Interface Design - Familiarity with e-commerce structures Experience: - Prior experience in building interactive quoting websites is a plus. My added description: the web site is very simple always a "register" button that will ask name, tel#, eMail ; location, location will be a drop down filled from the database, appt number. This pa...
I'm see...landscape project. I have the design brief of which i have plans/sections/sketches to illustrate my idea but i would like some help with the axonometric or isonometric drawings. It can be either one of those^ as it would count for the 3d view. I would like the approach to not necessarily be traditional or modern but mixed. i would like it to be a biophilic design as it is an open space seating area (outdoors) for the public, it is right by the riverside. I have a PDF with all the details and requirments, also with my work so far to give you a better idea. Ideal Skills: - Proficient in architectural rendering - Strong understanding of mixed style aesthetics - Experienced in rendering landscapes and exterio...
I'm searching for a creative freelancer to help elevate our brand's presence on Instagram. The primary focus will be creating vibrant and colorful content that drives...brand's presence on Instagram. The primary focus will be creating vibrant and colorful content that drives sales and features customer testimonials. Key Responsibilities: - Crafting engaging Instagram posts and videos with a customer testimonial focus. - Utilizing a bright and colorful aesthetic to capture attention and drive engagement. Ideal Skills: - Proven experience in social media content creation, particularly Instagram. - A knack for creating visually appealing and engaging content. - Ability to understand and translate brand values into social media content. - Experience wi...
...for SSWEB. The site should reflect our brand’s values and offer an exceptional user experience while maintaining a professional and aesthetically pleasing design. Key Features Required: Home Page: Engaging and visually appealing with an easy-to-navigate layout. About Us Page: Clear and concise information about our business, mission, and values. Product/Service Pages: Detailed pages showcasing our offerings, with the option to easily update and add new products or services. Contact Us Page: Form for inquiries, with map integration, contact information, and social media links. Responsive Design: The website should be fully responsive across mobile, tablet, and desktop devices. SEO Optimized: The website should be built with SEO best pract...
Are you a skilled Power BI Developer with a passion for turning raw data into actionable insights? We’re looking for a freelance professional to help us unlock the full potential of our data with dynamic dashboards and tailored analytics solutions. What We Need: • Expertise in Power BI: Custom dashboards, data modeling, and advanced DAX formulas. • Experience with integrating data from multiple sources (SQL, Excel, APIs, etc.). • Strong understanding of business intelligence and data visualization principles. • Ability to create visually compelling and interactive reports tailored to specific business needs. • Excellent communication and problem-solving skills. Your Responsibilities: • Collaborate ...
